DirectoryMissingMachine¶
Machines that are in Active Directory but not in the OctoSAM Inventory database. Used to diagnose missing scanner invocation policies.
Fields¶
| Field | Type | Description |
|---|---|---|
| AccountExpires | datetime2 | From Active Directory |
| Checked | datetime2 | Date/Time this machine was last checked from Active Directory with the database |
| ContainerPath | nvarchar | Distinguished name of the container of this machine. Provided for grouping and export |
| CustomField1 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField2 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField3 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField4 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| Description | nvarchar | Description attribute from Active Directory |
| Disabled | bit | True if UserAccountControl has the computer account disabled flag set |
| DomainName | nvarchar | NETBIOS domain name as specified in the import service configuration |
| EntraIdTenantId | uniqueidentifier | Entra ID tenant id |
| Ext1 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext2 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext3 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext4 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| ExtensionAttribute1 | nvarchar | From Active Directory |
| ExtensionAttribute10 | nvarchar | From Active Directory |
| ExtensionAttribute11 | nvarchar | From Active Directory |
| ExtensionAttribute12 | nvarchar | From Active Directory |
| ExtensionAttribute13 | nvarchar | From Active Directory |
| ExtensionAttribute14 | nvarchar | From Active Directory |
| ExtensionAttribute15 | nvarchar | From Active Directory |
| ExtensionAttribute2 | nvarchar | From Active Directory |
| ExtensionAttribute3 | nvarchar | From Active Directory |
| ExtensionAttribute4 | nvarchar | From Active Directory |
| ExtensionAttribute5 | nvarchar | From Active Directory |
| ExtensionAttribute6 | nvarchar | From Active Directory |
| ExtensionAttribute7 | nvarchar | From Active Directory |
| ExtensionAttribute8 | nvarchar | From Active Directory |
| ExtensionAttribute9 | nvarchar | From Active Directory |
| ExtraData | nvarchar | Extra data for this item. OctoSAM internal. |
| Guid | uniqueidentifier | Active Directory objectGuid |
| ID | bigint | Internal ID for the DirectoryMissingMachine entity (Primary Key) |
| LastLogonTimestamp | datetime2 | LastLogonTimestam attribute from Active Directory |
| Location | nvarchar | Location attribute from Active Directory |
| MappingTag | nvarchar | Reserved for organization mapping |
| Name | nvarchar | Machine name |
| NoScan | bit | If true this machine should not be scanned. It is ignored for scan coverage reporting. |
| OperatingSystem | nvarchar | OperatingSystem attribute from Active Directory |
| OperatingSystemFamily | nvarchar | A short name for the operating system family. WIN for Windows, Linux for Linux, ESX for Vmware ESX etc. |
| OperatingSystemPublisher | nvarchar | Publisher of the OS. Denormalized from SoftwarePublisher.Name |
| OperatingSystemServer | bit | True if a server operating system was detected |
| OperatingSystemServicePack | nvarchar | OperatingSystemServicePack attribute from Active Directory |
| OperatingSystemVersion | nvarchar | OperatingSystemVersion attribute from Active Directory |
| OrganizationID | bigint | Internal ID that references the Organization entity (Foreign Key) |
| Path | nvarchar | Distinguished name of this machine in Active Directory |
| PrintableName | nvarchar | Combined attributes to use for display and reports |
| Source | nvarchar | Source from where this computer object was read. Refers to import service configuration. |
| UserAccountControl | bigint | UserAccountControl attribute from Active Directory |
| WhenChanged | datetime2 | From Active Directory |
| WhenCreated | datetime2 | From Active Directory |