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)