Software usage per user¶
Note
This query requires the METERING license option.
Lists all users with all software packages they use, including metering information on the packages - if available.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Organization ID | numeric | false | Internal ID that references the Organization entity (Foreign Key) |
| Organization | string | true | Name of the organization this entity is mapped to |
| Organization Description | string | false | Description for the organization this entity is mapped to |
| User ID | numeric | false | Internal ID for the User entity (Primary Key) |
| User Guid | guid | false | A unique ID that can be used to link to this user object by external applications, |
| User | string | true | Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users |
| Domain Name | string | false | Domain of the logged on user, |
| Login Name | string | false | sAMAccount name, |
| User Principal Name | string | false | UserPrincipalName from the directory service, |
| string | false | Mail attribute from Active Directory | |
| Employee ID | string | false | EmployeeID attribute from Active Directory |
| Department Number | string | false | DepartmentNumber attribute from Active Directory |
| User Description | string | false | Description attribute from the directory service, |
| Directory Company | string | false | Directory attribute from Active Directory |
| Directory Title | string | false | Title (JobTitle) attribute from Active Directory |
| Directory Department | string | false | Department from Active Directory |
| Directory Home Directory | string | false | HomeDirectoy attribute from Active Directory |
| 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 |
| User Last Scan | date | false | Date/Time of last scan of this user. User info may stem from multiple sources. Time can by out of sync for users scanned on client machines. |
| Software Category ID | numeric | false | OctoSAM internal ID of this Software Category entity |
| Software Category | string | true | Software category name form the OctoSAM software catalog |
| Software Package ID | numeric | false | OctoSAM internal ID of this software package entity |
| 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 |
| Software Publisher ID | numeric | false | OctoSAM internal ID of this software publisher entity |
| Software Publisher Guid | guid | false | Unique identifier for objects that are synchronized with the master catalog |
| Software Publisher | string | true | Normalized software publisher from the OctoSAM catalog |
| Licensing Relevant | bool | true | True if the package or licensing type is considered relevant for licensing |
| Junk | bool | false | This software category or signature is marked as 'Junk'. It should not have any influence on software licensing. |
| Usage Days | numeric | true | Number of days the user was recorded using the package on a machine within the selected timespan. Usage on multiple machines increases the count. |
| Max Usage Time | numeric | true | Maximum time the package was used on one day and machine within the selected timespan |
| Min Usage Time | numeric | true | Minimum time the package was used on one day and machine within the selected timespan (excluding days with no usage) |
| Avg Usage Time | numeric | true | Average time the package was used within the selected timespan (excluding days with no usage) |
| First Usage | date | true | First usage within the selected timespan |
| Last Usage | date | true | Last usage within the selected timespan |
| Total Usage Time | numeric | true | Total time the package was used within the selected timespan (excluding days with no usage) |
| Metered Since | date | true | First recorded usage of the package within the whole database regardless of installation, user or selected timespan |
| Custom Field1 | string | false | Available for custom data, not used by OctoSAM Inventory, |
| Custom Field2 | string | false | Available for custom data, not used by OctoSAM Inventory, |
| Custom Field3 | string | false | Custom Data - not used by OctoSAM Inventory |
| Custom Field4 | string | false | Custom Data - not used by OctoSAM Inventory |
| 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 | 992a62d5-fba5-44f8-991f-be22e28018e3 | 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 |