| Machine ID |
numeric |
false |
Internal ID for the Machine entity (Primary Key) |
| Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Organization |
string |
true |
Name of the organization this entity is mapped to |
| Machine |
string |
true |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Machine Name |
string |
false |
Machine name (computer name) |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Directory Path |
string |
false |
Path where the machine was found in the directory service. Usually an LDAP path. |
| Directory Container Path |
string |
false |
Path to the container of this object. Provided for grouping or export to other applications. |
| Directory Site Name |
string |
false |
Active Directory Site that the machine belongs to |
| Most Frequent User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Most Frequent User Guid |
guid |
false |
OctoSAM internal Guid of the user that is most frequently using this machine |
| Most Frequent User Organization |
string |
true |
|
| Most Frequent User Organization ID |
numeric |
false |
|
| Most Frequent User Login |
string |
false |
|
| Most Frequent User Domain Name |
string |
false |
|
| Most Frequent User |
string |
true |
User that is most frequently using this machine |
| Most Frequent User Display Name |
string |
false |
|
| Most Frequent User Principal Name |
string |
false |
|
| Most Frequent User Mail |
string |
false |
|
| First Scan |
date |
false |
Date/Time of first scan of this machine |
| Last Scan |
date |
true |
Date/Time this entity got scanned last |
| Metered Since |
date |
true |
Date of first usage metering record for this machine |
| Min Date |
date |
false |
Start date for Usage calculateion |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
| 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. |
| Metering Incomplete |
bool |
true |
True if metering data for this machine does not cover the selected usage metering period |
| Python Usage |
numeric |
true |
Usage time within the selected period for python and python w exe utables |
| Conda Usage |
numeric |
true |
Usage time within the selected priod for the conda package manager |
| Pip Usage |
numeric |
true |
Usage time within the selected period for the pip package manager |
| Jupyter Usage |
numeric |
true |
Usage time within the selected period for Jupyter notebooks |
| Spyder Usage |
numeric |
true |
Usage time within the selected period for the Spyder IDE |
| Pycharm Usage |
numeric |
true |
Usage time within the selected period for JetBrains pyCharm IDE |
| Vs Code Usage |
numeric |
true |
Usage time within the selected period for Microsoft Visual Studio Code. Note that not all usage of VS Code needs to be python related |
| Operating System |
string |
false |
Full name of the OS |
| Operating System Server |
bool |
false |
True if this OS is a server version |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |