Skip to content

DirectoryMissingMachine

Machines that are in Active Directory but not in the OctoSAM Inventory database. Used to diagnose missing scanner invocation policies.

erDiagram
    Organization ||--o{ DirectoryMissingMachine : "OrganizationID"
    DirectoryMissingMachine ||--o{ DirectoryMissingMachineGroup : "DirectoryMissingMachineID"

Fields

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

References

Column Name Referenced Table Description
OrganizationID Organization Defines the organizations of this OctoSAM installation

Referenced by

Table Column Name Description
DirectoryMissingMachineGroup DirectoryMissingMachineID m:n relation Group to DirectoryMissingMachine