| 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 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 defining your own custom packages directly in the database. |
| Software Category ID |
numeric |
false |
Internal ID that references the SoftwareCategory entity (Foreign Key) |
| Software Category |
string |
true |
Name of the software category |
| Software Category Description |
string |
false |
Description |
| Junk |
bool |
false |
Flag to signal a category as junk. junk categories can be ignored on some reports and queries. |
| Software Package |
string |
true |
Name of the software package |
| Custom Field1 |
string |
false |
Custom data not used by OctoSAM |
| Custom Field2 |
string |
false |
Custom data not used by OctoSAM |
| Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Metering Enabled |
bool |
false |
True, if the software package definition supports package metering |
| Predefined By Octopus |
bool |
false |
The package definition is maintained through OctoSAM master catalog updates |
| Predefined Site Specific |
bool |
false |
The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher |
string |
true |
Software publisher's name |
| Software Publisher Guid |
guid |
false |
Unique identifier for objects that are synchronized with the master catalog |
| Software Publisher Url |
string |
true |
Link to the Website |
| Software Licensing Type |
string |
true |
Name |
| Licensing Relevant |
bool |
true |
True for commercial licensing types |
| User Installed |
bool |
true |
True when at least one instance of this software package on this machine was installed within a user context |
| 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 |
| Installation Licensing Relevant |
bool |
false |
This particular installation is licensing relevant. For Java packages this means that an Oracle licence is required |
| Installation Approved |
bool |
false |
|
| Installation Approved Changed |
date |
false |
|
| Installation Approved Changed By |
string |
false |
|
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |