SoftwarePackage (Internal)¶
OctoSAM Internal Query
Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.
All rows and columns from the SoftwarePackage table.
Fields¶
Name | Type | Visible | Description |
---|---|---|---|
ID | numeric | true | OctoSAM internal ID of this entity |
Name | string | true | Name of the software package |
Notes | string | true | Custom notes |
Software Category ID | numeric | true | OctoSAM internal ID of this Software Category entity |
Software Publisher ID | numeric | true | OctoSAM internal ID of this software publisher entity |
Last Modification | date | true | Date/Time this entity was last updated. In most cases, this is the time of the last import. In case of re-import of older scan files, LastModification can differ significantly from LastScan. |
Deployment Group | string | true | Can be used to assign security groups to machine objects in the directory. Some software deployment systems use this to determine what package to install on what machine (or for which user). |
Metering Enabled | bool | true | True, if the software package definition supports package metering. |
Custom Field1 | string | true | Custom data not used by OctoSAM |
Custom Field2 | string | true | Custom data not used by OctoSAM |
Predefined By Octopus | bool | true | The package definition is maintained through OctoSAM master catalog updates |
Predefined Site Specific | bool | true | The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates |
Custom Field3 | string | true | Custom Data - not used by OctoSAM Inventory |
Custom Field4 | string | true | Custom Data - not used by OctoSAM Inventory |
Synch Token ID | string | true | Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory. |
Synch Last Synch | date | true | Date/Time of last synchronization of this software package with the partner CMDB. Not used by OctoSAM Inventory. |
Auto Assign Enabled | bool | true | Auto assign rules for new signatures enabled |
Auto Assign Regex | string | true | A regular expression that is used to automatically assign new signatures to this software package |
Auto Assign Test Like Pattern | string | true | SQL LIKE and/or regular expression pattern used to select signatures for auto assign testing |
Last Modified By | string | true | Client User that last modified this software package through the Octopus UI |
Deployment Action | string | true | Used for deployment consolidation. Can be 'U' for Unknown, 'A' for Approved, 'R' for Replace with, or 'I' for Ignored. |
Deployment Replacement Software Package ID | numeric | true | Internal ID that references the SoftwarePackage entity (Foreign Key) |
Res1 | string | true | Reserved for internal use by future versions |
Res2 | string | true | Reserved for internal use by future versions |
Created | date | true | Date/Time this entity was created |
Created By | string | true | User that created the package |
Created Guid | guid | true | Reserved for future use |
Keep Dynamic Machine Signature Relations | bool | true | Prevents automatic dynamic signature to machine reorg. Dynamic signatures (processes) to machine relations are cleared after 10 days if they are not in a software package with static signature relations to the same machine or this flag set. |
Guid | guid | true | GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
Software Licensing Type ID | numeric | true | OctoSAM internal ID for licensing type |
Last Update From Master | date | true | Date/Time a software catalog update last updated this package |
Last Synch With Master | date | true | Date/Time time a software catalog update contained this package |
Master Last Modified | date | true | Date/Time master definition was updated. by Octosoft. |
Master Last Modified By | string | true | User that updated the softwrae catalog |
Master Notes | string | true | Package master catalog notes |
Auto Assign Notes | string | true | Notes about quirks in the AutoAssign rules |
Swid Tag May Remain On Uninstall | bool | true | Set to true for software that routinely leaves the swid tag file behind on uninstall. Adobe is known for this behaviour. |
Ignore Signature Publishers | bool | true | If set to true, OcoSAM Inventory does not try to find the package publisher based on signature publishers. |
Metering Regex | string | true | Reserved for future use |
Metering Test Like Pattern | string | true | Reserved for future use |
Auxiliary Regex | string | true | Reserved for future use |
Auxiliary Test Like Pattern | string | true | Reserved for future use |
Software Product Version ID | numeric | true | Reserved for future use |
Edition Name | string | true | Reserved for future use |
Edition Priority | numeric | true | Reserved for future use |
Hint Software Package Usage Start Date | date | true | Min consolidated usage date for this software package |
Hint Software Package Usage End Date | date | true | Max consolidated usage date for this Package |
Hint Has Software Items | bool | true | True if the software package is linked to at least one software item |
Customer ID | guid | true | A guid that indicates the customer for client specific packages |
Installation ID | guid | true | Reserved for future use, |
Analysis Extras | string | true | Holds additional analysis data, |
Service Now Sys ID | guid | true | Service Now: sys_id of replicated object, |
Service Now Last Export | date | true | Date/Time of last export to ServiceNow, |
Service Now Last Import | date | true | Date/Time of last import from ServiceNow, |
Extra Data | string | true | Extra data for this object (JSON) |
Lifecycle Support Policy | string | true | For package specific software life cycle: contains a publisher specific life cycle policy name, |
Lifecycle Start Date | date | true | For package specific software life cycle: life cycle start date, |
Lifecycle Mainstream End Date | date | true | For package specific software life cycle: mainstream support end date |
Lifecycle Extended End Date | date | true | For package specific software life cycle: extended support end date |
Lifecycle Retirement Date | date | true | Reserved for future use, |
Lifecycle Release Start Date | date | true | Reserved for future use, |
Lifecycle Release End Date | date | true | Reserved for future use, |
Lifecycle Long Term Support | bool | true | For package specific software life cycle: true if a long term support release |
Lifecycle Definition Type ID | numeric | true | OctoSAM internal ID of this software lifecycle definition |
Lifecycle Notes | string | true | Notes from the lifcycle definition for packages that have a package specific lifecycle definition, |
Always Create Package | bool | true | If true, the package always gets created in the database regardless of installation status, |
Current Date Time | date | false | Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query¶
Query information¶
Property | Value | Description |
---|---|---|
Query Guid | fac2b7b2-5a08-439b-a3a7-918a234cbe32 | The internal id of the query. Must be unique |
SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
SupportsWeb | false | If true, the query can be started from the OctoSAM Web UI |