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 |