Skip to content

Infrequently used machines

Find machines with only few scanned logins during the selected period. This query does not find machines that have never been scanned.

Fields

Name Type Visible Description
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
Site string true Name of the Active Directory Site that this machine belogs to
Machine string true Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Name string false Machine name (computer name)
Domain Name string false Windows NETBIOS Domain Name
Description string false Description attribute of the directory service or manually entered during offline scan
Operating System string true Operating System installed on this machine as reported by OctoSAM scanners
Operating System Family string false A short name to identify different operating system families
Operating System Build string false Build number of the OS
Operating System Update Build Revision numeric false Windows UBR number
Operating System Server bool false True if this OS is a server version
Scanned Logins numeric true Number of logins detected by OctosSAM scanner
Distinct Software Usage Days numeric true Number of days with metered software usage for this machine during the selected timespan
Scan Files Produced numeric true Number of scan files produced during the selected timespan
First Scan date true Date/Time this entity got scanned first
Last Scan date true Date/Time this entity got scanned last
Day Spread numeric true Number of days between first and last scan of this machine
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 Last Logon Timestamp date true LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
Directory Ext1 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Directory Ext2 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Directory Ext3 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Directory Ext4 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Directory Extension Attribute1 string false ExtensionAttribute from Active Directory
Directory Extension Attribute2 string false ExtensionAttribute from Active Directory
Directory Extension Attribute3 string false ExtensionAttribute from Active Directory
Directory Extension Attribute4 string false ExtensionAttribute from Active Directory
Directory Extension Attribute5 string false ExtensionAttribute from Active Directory
Directory Extension Attribute6 string false ExtensionAttribute from Active Directory
Directory Extension Attribute7 string false ExtensionAttribute from Active Directory
Directory Extension Attribute8 string false ExtensionAttribute from Active Directory
Directory Extension Attribute9 string false ExtensionAttribute from Active Directory
Directory Extension Attribute10 string false ExtensionAttribute from Active Directory
Directory Extension Attribute11 string false ExtensionAttribute from Active Directory
Directory Extension Attribute12 string false ExtensionAttribute from Active Directory
Directory Extension Attribute13 string false ExtensionAttribute from Active Directory
Directory Extension Attribute14 string false ExtensionAttribute from Active Directory
Directory Extension Attribute15 string false ExtensionAttribute from Active Directory
Directory When Created date false WhenCreated attribute from Active Directory
Directory When Changed date false WhenChanged attribute from Active Directory (updated on import and on housekeeping)
Raw Manufacturer string false Manufacturer of the machine as defined in WMI
Manufacturer ID numeric false Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer string false Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model string true Model of the Machine as defined in WMI
Last User ID numeric false Internal ID that references the User entity (Foreign Key)
Last User Guid guid false OctoSAM internal guid of the user that last used this machine
Last User Organization ID numeric false
Last User string true User that last used this machine
Last User Login Name string false Login name of the last user that used this machine
Last User Domain Name string false Domainname of the last user that used this machine
Last User Display Name string false
Last User Principal Name string false
Last User Mail string false
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 ID numeric false
Most Frequent User string true User that is most frequently using this machine
Most Frequent User Login Name string true
Most Frequent User Domain Name string false
Most Frequent User Display Name string false
Most Frequent User Principal Name string false
Most Frequent User Mail string false
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 bd32f8c8-6d7e-4ba3-a713-b40ae0c9a1fd The internal id of the query. Must be unique
SupportsDesktop true If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb true If true, the query can be started from the OctoSAM Web UI