Skip to content

Repackaging info per machine

Note

This query requires the REPACKAGING license option.

Find all machines with some hardware information and all installed software packages plus metering information and repackaging on the packages if available. This query selects only software packages that have at least on installation with repackaging information

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
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
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)
Alternate Name string false Contains the computer name for systems that may have different host and computer names, such as macOS.
Machine Description string false Description attribute of the directory service or manually entered during offline scan
Domain Name string false Windows NETBIOS Domain Name
Site string false Name of the Active Directory Site that this machine belogs to
Location string false Location attribute from Active Directory
Network Address string false Network address, usually the IP number.
Network Mac Address string false MAC address of the main interface (corresponds to NetworkNetworkAddress
Network Subnet Mask string false Subnet mask if network address is an ip number
Virtual Machine bool true True if this is a virtual machine
Raw Manufacturer string true Manufacturer of the machine as defined in WMI
Manufacturer ID numeric true Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer string true Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model string true Model of the Machine as defined in WMI
Chassis Types string false ChassisTypes as reported in WMI in cleartext
Processor string false Processor Name as reported by WMI
Number Of Processors numeric false Number of processors as reported by WMI
Number Of Logical Processors numeric false Number of logical processors as reported by WMI
Number Of Cores numeric false Number of cores as reported by WMI
Physical Memory Gi B numeric false Installed Memory in GiB (Gibibyte)
Network Network Address string false Network address calculated from NetworkAddress and NetworkSubnetkMask fields
Operating System string true Operating System installed on this machine as reported by OctoSAM scanners
Operating System Server bool false True if this OS is a server version
Operating System Version string false Additional version information about the OS
Last Scan date true Date/Time this entity got scanned last
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 definig your own custom packages directly in the database.
Software Package string true Software package name from the OctoSAM software catalog
Metering Enabled bool false True, if the software package definition supports package metering.
Repackager Info string true Per installation repackager specific info
Software Category string true Software category name form the OctoSAM software catalog
Software Publisher string true Normalized software publisher from the OctoSAM catalog
Auto Assign Enabled bool false Auto assign rules for new signatures enabled
Software Package Usage Days numeric true Usage days within the selected timespan
Metered Since date true First recorded usage of the package within the whole database regardless of installation, user or selected timespan
First Usage date true First usage within the selected timespan
Last Usage date true Last usage within the selected timespan
Licensing Type ID numeric false OctoSAM internal ID for licensing type
Licensing Type string true Licensing type for this package as defined in the OctoSAM Inventory software catalog
Licensing Relevant bool true True if the package or licensing type is considered relevant for licensing
Junk bool true This software category or signature is marked as 'Junk'. It should not have any influence on software licensing.
Last Found In Directory date true Time the object was last found in the directory service
Directory Path string true Path to this user or machine object in Active Directoy
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 string true User that is most frequently using this machine
MFU Last Scan date true Date/Time the most frequent user on this machine got last scanned
MFU Local Administrator bool true True if the most frequent user on this machine had administrator rights at last scan
MFU Last Login Was Remote bool true True if the most frequent user's last scanned login was from remote
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 string true User that last used this machine
LU Last Scan date true Date/Time the last user on this machine got last scanned
LU Was Local Administrator bool true True if the last user on this machine had administrator rights at last scan
LU Login Was Remote bool true True if the last users login was from remote
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
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 ee9eca01-3159-444e-a003-ca114d98eab6 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