Duplicate SMBIOS UUID¶
Find potential orphaned machines with SMBIOS UUID. This may happen if existing machines get re-installed and/or renamed. The IsNewest flag marks the PC with the newest scan date, most likely the currently active machine.
UUIDs may not be unique
While most enterprise class PCs do have a unique UUID, this may not be the case with some generic PC models.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Bios Smbios Uuid | guid | true | SMBIOS UUID of the machine |
| Bios Serial Number | string | true | BIOS Serial Number as reported by WMI |
| Machine Count | numeric | true | Number of machines with same serial number |
| 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 |
| Last Scan | date | true | Date/Time this entity got scanned last |
| Directory Last Logon Timestamp | date | false | LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days. |
| Is Newest | bool | true | If true, this is the newest machine scanned |
| 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 |
| Virtual Machine | bool | true | True if this is a virtual machine |
| 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 |
| Most Frequent User ID | numeric | false | Internal ID that references the User entity (Foreign Key) |
| Most Frequent User Guid | guid | true | 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 Display Name | string | false | |
| Most Frequent User Login Name | string | false | |
| Most Frequent User Domain Name | string | true | |
| 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 | da43f09d-a985-47a5-a779-d0458d7b6516 | 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 |