test
Tables (3)
Computer_System_DATA
- MachineID — int — Primary key — NOT NULL
- InstanceKey — int — Primary key — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeKey — datetime — NOT NULL
- rowversion — timestamp — NOT NULL
- AdminPasswordStatus00 — int
- AutomaticResetBootOption00 — int
- AutomaticResetCapability00 — int
- BootOptionOnLimit00 — int
- BootOptionOnWatchDog00 — int
- BootROMSupported00 — int
- BootupState00 — nvarchar(255)
- Caption00 — nvarchar(255)
- ChassisBootupState00 — int
- CurrentTimeZone00 — int
- DaylightInEffect00 — int
- Description00 — nvarchar(255)
- Domain00 — nvarchar(255)
- DomainRole00 — int
- FrontPanelResetStatus00 — int
- InfraredSupported00 — int
- InitialLoadInfo00 — nvarchar(255)
- InstallDate00 — datetime
- KeyboardPasswordStatus00 — int
- LastLoadInfo00 — nvarchar(255)
- Manufacturer00 — nvarchar(255)
- Model00 — nvarchar(255)
- Name00 — nvarchar(255)
- NameFormat00 — nvarchar(255)
- NetworkServerModeEnabled00 — int
- NumberOfProcessors00 — int
- OEMLogoBitmap00 — nvarchar(255)
- OEMStringArray00 — nvarchar(255)
- PauseAfterReset00 — nvarchar(255)
- PowerManagementCapabilities00 — nvarchar(255)
- PowerManagementSupported00 — int
- PowerOnPasswordStatus00 — int
- PowerState00 — int
- PowerSupplyState00 — int
- PrimaryOwnerContact00 — nvarchar(255)
- PrimaryOwnerName00 — nvarchar(255)
- ResetCapability00 — int
- ResetCount00 — int
- ResetLimit00 — int
- Roles00 — nvarchar(255)
- Status00 — nvarchar(255)
- SupportContactDescription00 — nvarchar(255)
- SystemStartupDelay00 — int
- SystemStartupOptions00 — nvarchar(255)
- SystemStartupSetting00 — int
- SystemType00 — nvarchar(255)
- ThermalState00 — int
- TotalPhysicalMemory00 — bigint
- UserName00 — nvarchar(255)
- WakeUpType00 — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- … +8
System_DISC
- ItemKey — int — Primary key — NOT NULL
- DiscArchKey — int
- SMS_Unique_Identifier0 — nvarchar(255)
- Netbios_Name0 — nvarchar(256)
- Name0 — nvarchar(256)
- Distinguished_Name0 — nvarchar(256)
- Operating_System_Name_and0 — nvarchar(256)
- Resource_Domain_OR_Workgr0 — nvarchar(256)
- Full_Domain_Name0 — nvarchar(256)
- AD_Site_Name0 — nvarchar(256)
- User_Name0 — nvarchar(256)
- Client0 — int
- Client_Type0 — int
- AgentEdition0 — int
- DeviceOwner0 — int
- Unknown0 — int
- Client_Version0 — nvarchar(256)
- Community_Name0 — nvarchar(256)
- User_Domain0 — nvarchar(256)
- Previous_SMS_UUID0 — nvarchar(255)
- SMS_UUID_Change_Date0 — datetime
- CPUType0 — nvarchar(256)
- Hardware_ID0 — nvarchar(256)
- Obsolete0 — int
- Active0 — int
- Creation_Date0 — datetime
- SMBIOS_GUID0 — nvarchar(256)
- AlwaysInternet0 — int
- InternetEnabled0 — int
- Decommissioned0 — int
- WipeStatus0 — int
- AMTStatus0 — int
- AMTFullVersion0 — nvarchar(256)
- IsClientAMT30Compatible0 — bit
- SuppressAutoProvision0 — bit
- Primary_Group_ID0 — int
- User_Account_Control0 — int
- SID0 — nvarchar(256)
- EAS_DeviceID — nvarchar(256)
- Object_GUID0 — varbinary(16)
- Last_Logon_Timestamp0 — datetime
- Is_Virtual_Machine0 — bit
- Is_MachineChanges_Persisted0 — bit
- Is_Assigned_To_User0 — bit
- Virtual_Machine_Host_Name0 — nvarchar(256)
- WTGUniqueKey — nvarchar(256)
- Is_Write_Filter_Capable0 — bit
- Is_Portable_Operating_System0 — bit
- Is_AOAC_Capable0 — bit
- PublisherDeviceID — nvarchar(64)
- IsReassigned0 — bit
- MdmStatus — nvarchar(256)
- MDMDeviceCategoryID0 — nvarchar(256)
- Virtual_Machine_Type0 — int
- Build01 — nvarchar(256)
- OSBranch01 — nvarchar(256)
- ManagementAuthority — int
- Build0 — nvarchar(256)
- OSBranch0 — nvarchar(256)
- SerialNumber — nvarchar(64)
- … +24
TB_AD_COM_INFO
- ItemKey — int — Foreign key → System_DISC.ItemKey — NOT NULL
- name — varchar(50)
- employeeID — varchar(50)
- lastLogon — datetime
- whenChanged — datetime
- whenCreated — datetime
- canonicalName — nvarchar(max)
- distinguishedName — nvarchar(max)
- userAccountControl — varchar(50)