| Machine ID |
numeric |
false |
OctoSAM internal ID of this Machine entity |
| Machine Guid |
guid |
false |
OctoSAM internal Guid of this Machine entity |
| Machine |
string |
false |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Software Category ID |
numeric |
false |
Internal ID that references the SoftwareCategory entity (Foreign Key) |
| Software Category |
string |
true |
Software category name form the OctoSAM software catalog |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package Guid |
guid |
false |
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 Package |
string |
true |
Software package name from the OctoSAM software catalog |
| Package Custom Field1 |
string |
false |
Custom data not used by OctoSAM |
| Package Custom Field2 |
string |
false |
Custom data not used by OctoSAM |
| Package Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Package Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Install Date |
date |
true |
Date this software package got installed. Depending on the installer used this date may not be available. |
| Installation Custom Field1 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field2 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field3 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field4 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Publisher Url |
string |
true |
Web Address of the software publisher |
| Software Licensing Type ID |
numeric |
false |
Internal ID that references the SoftwareLicensingType entity (Foreign Key) |
| Software Licensing Type |
string |
true |
Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |