Skip to content

Microsoft Office 2024 Usage

Show software usage details for Microsoft Office 2024.

Fields

Name Type Visible Description
Organization ID numeric false Internal ID that references the Organization entity (Foreign Key)
Organization Guid guid false
Organization string true Name of the organization
Organization Description string false Description
Environment ID numeric false Internal ID that references the Environment entity (Foreign Key)
Environment string false Name of the Environment
Organization Custom Field1 string false Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field2 string false Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field3 string false Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field4 string false Available for custom data, not used by OctoSAM Inventory,
Object State ID numeric false Internal ID that references the ObjectState entity (Foreign Key)
Object State string false Object state name
Object State Octopus Id string false Octopus technical name of this state
Machine Guid guid false A unique ID that can be used to link to this machine object by external applications
Machine ID numeric false Internal ID for the Machine entity (Primary Key)
Machine Name string false Machine name (computer name)
Machine string true Use this name in reports for consistency and to avoid having to build the printable name from its parts
Alternate Name string false Contains the computer name for systems that may have different host and computer names, such as macOS.
Fully Qualified Domain Name string false Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Machine Description string false Description attribute of the directory service or manually entered during offline scan
Alternate Description string false Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
Domain Name string false Windows NETBIOS Domain Name
Site string false Active Directory Site that the machine belongs to
Location string false Active Directory location attribute
Sid string false Computer SID
Operating System string true Full name of the OS
Operating System Publisher string false Publisher of the OS.
Operating System Family string false A short name to identify different operating system families
Operating System Server bool false True if this OS is a server version
Operating System Version string false Additional version information about the OS
Operating System Display Version string false DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID.
Operating System Edition string false An OS specific edition marker
Operating System Bits numeric false 32 or 64 bit
Last Scan Guid guid false GUID of the last imported .scan file for this entity.
First Scan date false Date/Time of first scan of this machine
Last Found In Entra Id date false Date/Time this device was last found in Entra ID
Last Found In Directory date false Time the object was last found in the directory service
Deleted In Directory bool false True, if directory check detects that the machine is no longer found in directory.
Deleted In Directory First Detected date false Date/Time the delete flag was set
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.
Entra Id Tenant Id guid false Entra ID tenant id for machines that are Entra ID joined
Entra Id Id string false ID from Entra ID
Entra Id Device Id string false Device ID from Entra ID
Entra Id Device Ownership string false DeviceOwnership field from Entra ID
Entra Id Enrollment Profilename string false EnrollmentProfileName field from Entra ID
Entra Id On Premises Sync Enabled bool false True if on premises sync is enabled for this machine in Entra ID
Entra Id On Premises Last Sync Date Time date false OnPremisesLastSyncDateTime field from Entra ID
Entra Id Approximate Last Sign In Date Time date false ApproximateLastSignInDateTime field Entra ID
Entra Id Trust Type string false TrustType field from Entra ID
Entra Id Profile Type string false ProfileType field from Entra ID
Entra Id Registration Date Time date false RegistrationDateTime field from Entra ID
Entra Id Is Managed bool false True if this machine is managed by Entra ID MDM policies
Entra Id Is Compliant bool false True if this machine is deemed compliant to Entra ID MDM policies
Manufacturer ID numeric false Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer string false Normalized hardware manufacturer name
Raw Manufacturer string false Manufacturer of the machine as defined in WMI
Model string true Model of the Machine as defined in WMI
Bios Serial Number string false BIOS Serial Number as reported by WMI
Processor string false Processor Name as reported by WMI
Processor Speed numeric false Max speed of the processor in MHz
Number Of Processors numeric false Number of processors as reported by WMI
Number Of Cores numeric false Number of cores as reported by WMI
Number Of Logical Processors numeric false Number of logical processors as reported by WMI
Oracle Core Factor object false Oracle Core Factor to use for Oracle pricing. Queries should alwas use this field.
Physical Memory numeric false Amount of physical memory in the system as reported by WMI
Chassis Types string false ChassisTypes as reported in WMI in cleartext
Directory Last Logon Timestamp date false LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
Directory Last Logon Last Scan Diff numeric false
Directory When Created date false WhenCreated attribute from Active Directory
Directory Disabled bool false True if the UserAccountControl attribute has the disable bit set
Most Frequent User ID numeric false Internal ID that references the User entity (Foreign Key)
Most Frequent User string true Combination of attributes for consisten naming on screen or in reports
Most Frequent User Guid guid false A unique ID that can be used to link to this user object by external applications,
Most Frequent User Organization ID numeric false Internal ID that references the Organization entity (Foreign Key)
Most Frequent User Principal Name string false UserPrincipalName from the directory service,
Most Frequent User Mail string false Mail attribute from Active Directory
Most Frequent User Domain Name string false Domain of the logged on user,
Most Frequent User Login Name string false SAMAccount name,
Last User ID numeric false Internal ID that references the User entity (Foreign Key)
Last User string false Combination of attributes for consisten naming on screen or in reports
Last User Guid guid false A unique ID that can be used to link to this user object by external applications,
Last User Organization ID numeric false Internal ID that references the Organization entity (Foreign Key)
Custom Field1 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field2 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field3 string false Available for custom data for this Machine, not used by OctoSAM Inventory
Custom Field4 string false Available for custom data for this Machine, not used by OctoSAM Inventory
Virtual Machine bool true True if this is a virtual machine
Virtualization Host bool false True if this machine hosts virtual machines
Last Scan date true Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
Users numeric true Number of users that have used the machine
Professional Installed bool true True if Office 2024 Professional is installed on the machine
Pro Package Usage Days numeric true Number of days the Professional package has been used
Pro Package Usage Total Minutes numeric true Total minutes the Professional package has been used
Word Pro Minutes numeric true Minutes Word has been used
Excel Pro Minutes numeric true Minutes Excel has been used
Outlook Pro Minutes numeric true Minutes Outlook has been used
Power Point Pro Minutes numeric true Minutes PowerPoint has been used
Access Minutes numeric true Minutes Access has been used
Standard Installed bool true True if Office 2024 Standard is installed on the machine
Std Package Usage Days numeric true Number of days the Standard package has been used
Std Package Usage Total Minutes numeric true Total minutes the Standard package has been used
Word Std Minutes numeric true Minutes Word has been used
Excel Std Minutes numeric true Minutes Excel has been used
Outlook Std Minutes numeric true Minutes Outlook has been used
Powerpoint Std Minutes numeric true Minutes PowerPoint has been used
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 4bad3ff5-01b6-41ab-91de-5f5c5141b765 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