test
Tables (50)
CM_ClientDeploymentState
- RecordID — int — NOT NULL
- SecureMessage — bit
- SMSID — nvarchar(255)
- FQDN — nvarchar(512)
- NetBiosName — nvarchar(64)
- LastIDUpdateTime — datetime — NOT NULL
- LastMessageTime — datetime
- LastMessageStateID — int
- LastMessageParam — nvarchar(512)
- DeploymentBeginTime — datetime
- DeploymentEndTime — datetime
- AssignmentBeginTime — datetime
- AssignmentEndTime — datetime
- AssignedSiteCode — nvarchar(4)
- ClientVersion — nvarchar(64)
- CCMSetupVersion — nvarchar(64)
- RebootNeeded — nvarchar(1)
- LastRebootMessageTime — datetime
- LastErrorCode — int
- AutoUpgradeStartTime — datetime
- BaselineCookie — datetime
- ItemKey — int
- BaselineType — tinyint
- SourceType — nvarchar(4)
- SourceUrl — nvarchar(512)
- LastUpdatedTime — datetime
- DeploymentMethod — int
- InstalledLangs — nvarchar(512)
- AlwaysExcludeUpgrade — int
CM_CollectionMembers
- SiteID — nvarchar(8)
- MachineID — int — NOT NULL
- ArchitectureKey — tinyint — NOT NULL
- Name — nvarchar(255)
- Domain — nvarchar(255)
- SMSID — nvarchar(255)
- SiteCode — nvarchar(3)
- IsDirect — bit — NOT NULL
- IsAssigned — bit — NOT NULL
- IsClient — bit — NOT NULL
- Priority — int
- rowversion — timestamp
CM_Collection_Rules
- CollectionID — int — NOT NULL
- QueryKey — int — NOT NULL
- MachineID — int — NOT NULL
- ReferencedCollectionID — nvarchar(8)
- RuleType — int — NOT NULL
- QueryName — nvarchar(255)
- QueryComment — nvarchar(255) — varchar(255) NUL
- ArchitectureKey — int
- QueryCollectionID — nvarchar(8)
CM_Collections_G
- CollectionID — int — NOT NULL
- SiteID — nvarchar(8)
- LimitToCollectionID — nvarchar(8)
- CollectionName — nvarchar(255)
- Flags — int — NOT NULL
- ResultTableName — nvarchar(32)
- CollectionComment — nvarchar(512) — varchar(512) NUL
- Schedule — nvarchar(255)
- LastChangeTime — datetime
- SourceLocaleID — int
- LastRefreshRequest — datetime
- CollectionType — int — NOT NULL
- ISVData — varbinary(max)
- rowversion — timestamp
- ISVString — nvarchar(2048)
CM_INSTALLED_SOFTWARE_DATA
- MachineID — int — NOT NULL
- InstanceKey — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeKey — datetime — NOT NULL
- rowversion — timestamp — NOT NULL
- SoftwareCode00 — nvarchar(255)
- InstallType00 — int
- CM_DSLID00 — nvarchar(255)
- ProductName00 — nvarchar(255)
- ARPDisplayName00 — nvarchar(255)
- ProductVersion00 — nvarchar(255)
- Publisher00 — nvarchar(255)
- VersionMajor00 — int
- VersionMinor00 — int
- ServicePack00 — nvarchar(255)
- Language00 — int
- ProductID00 — nvarchar(255)
- InstalledLocation00 — nvarchar(255)
- InstallSource00 — nvarchar(255)
- UninstallString00 — nvarchar(255)
- LocalPackage00 — nvarchar(255)
- UpgradeCode00 — nvarchar(255)
- InstallDate00 — datetime
- RegisteredUser00 — nvarchar(255)
- SoftwarePropertiesHash00 — nvarchar(255)
- SoftwarePropertiesHashEx00 — nvarchar(255)
- InstallDirectoryValidation00 — int
- ChannelCode00 — nvarchar(255)
- MPC00 — nvarchar(255)
- ChannelID00 — nvarchar(255)
- EvidenceSource00 — nvarchar(255)
- OsComponent00 — int
- PackageCode00 — nvarchar(255)
CM_INSTALLED_SOFTWARE_DATA_Summary
- SoftwareCode00 — nvarchar(255)
- SoftwarePropertiesHash00 — nvarchar(255)
- ProductName00 — nvarchar(255)
- Publisher00 — nvarchar(255)
- ProductVersion00 — nvarchar(255)
- Count00 — int
- SiteNumber — int — NOT NULL
CM_INTERBERA_EXTENTION_SK_DATA
- MachineID — int — NOT NULL
- InstanceKey — int — NOT NULL
- TimeKey — datetime — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- rowversion — timestamp — NOT NULL
- Account00 — nvarchar(255)
- AssetTag00 — nvarchar(255)
- AssetTagDisc100 — nvarchar(255)
- AssetTagDisc200 — nvarchar(255)
- AssetTagDisc300 — nvarchar(255)
- AssetTagTime00 — nvarchar(255)
- AssetTagVersion00 — nvarchar(255)
- InstanceKey00 — nvarchar(255)
- LoginAccount00 — nvarchar(255)
- PCName00 — nvarchar(255)
CM_LU_Category_Local
- CategoryID — int — NOT NULL
- Type — tinyint — NOT NULL
- CategoryName — nvarchar(512)
- LanguageID — int
- Description — nvarchar(1024)
- LastUpdated — datetime — NOT NULL
- IsDeleted — bit — NOT NULL
- SourceSite — nvarchar(3)
- rowversion — timestamp — NOT NULL
CM_LU_SoftwareHash
- SoftwarePropertiesHash — nvarchar(64)
- Name — nvarchar(255)
- Version — nvarchar(255)
- Publisher — nvarchar(255)
- SoftwareID — nvarchar(36)
- LocaleID — int
- LastUpdated — datetime — NOT NULL
- IsDeleted — bit — NOT NULL
- SourceSite — nvarchar(3)
- rowversion — timestamp — NOT NULL
CM_LU_SoftwareList_Local
- SoftwareID — nvarchar(36) — NOT NULL
- SoftwarePropertiesHash — nvarchar(64) — NOT NULL
- CommonName — nvarchar(255)
- CommonVersion — nvarchar(255)
- CommonPublisher — nvarchar(255)
- CategoryID — int
- FamilyID — int
- Tag1ID — int
- Tag2ID — int
- Tag3ID — int
- LocaleID — int
- ConflictStatus — int
- LastUpdated — datetime — NOT NULL
- IsDeleted — bit — NOT NULL
- ID — int — NOT NULL
- SourceSite — nvarchar(3)
- rowversion — timestamp — NOT NULL
- ParentSoftwareID — nvarchar(64)
- ParentSoftwarePropertiesHash — nvarchar(64)
CM_RecentlyUsedApps_DATA
- MachineID — int — NOT NULL
- InstanceKey — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeKey — datetime — NOT NULL
- rowversion — timestamp — NOT NULL
- FolderPath00 — nvarchar(255)
- ExplorerFileName00 — nvarchar(255)
- LastUserName00 — nvarchar(255)
- OriginalFileName00 — nvarchar(255)
- FileVersion00 — nvarchar(255)
- FileSize00 — int
- ProductName00 — nvarchar(255)
- ProductVersion00 — nvarchar(255)
- ProductLanguage00 — int
- FileDescription00 — nvarchar(255)
- CompanyName00 — nvarchar(255)
- LaunchCount00 — int
- LastUsedTime00 — datetime
- ProductCode00 — nvarchar(255)
- AdditionalProductCodes00 — nvarchar(255)
- msiDisplayName00 — nvarchar(255)
- msiPublisher00 — nvarchar(255)
- msiVersion00 — nvarchar(255)
- SoftwarePropertiesHash00 — nvarchar(255)
- FilePropertiesHash00 — nvarchar(255)
CM_SMSData
- ThisSiteCode — nvarchar(3)
- ThisSiteName — nvarchar(200)
- ThisSiteGuid — nvarchar(64)
- SMSVersion — nvarchar(8)
- SMSBuildNumber — int
- SMSMinBuildNumber — int
- ServiceAccountName — nvarchar(255)
- SMSProviderServer — nvarchar(128)
- SMSSiteServer — nvarchar(128)
- LocaleID — int
- InstallDate — datetime
- LastTimeSerial_MUS — int
- LastTimeSerial_FUS — int
- SiteNumber — int
- SiteSid — nvarchar(256)
- SMSAvailableConsoleVersion — nvarchar(32)
- BoundaryGroupCacheTimestamp — datetime
- MonthlyReleaseVersion — int
CM_SYNONYM
- nm_SYNONYM — nvarchar(100)
- nm_DB — nvarchar(128)
CM_System_DISC
- ItemKey — int — 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)
- … +8
CM_System_System_OU_Name_ARR
- ItemKey — int — NOT NULL
- System_OU_Name0 — nvarchar(446)
CM_Update_ComplianceStatus
- CI_ID — int — NOT NULL
- MachineID — int — NOT NULL
- Status — tinyint — NOT NULL
- LastStatusCheckTime — datetime
- LastStatusChangeTime — datetime
- EnforcementSource — tinyint
- LastEnforcementMessageID — tinyint
- LastEnforcementMessageTime — datetime
- LastEnforcementStatusMsgID — int
- LastErrorCode — int
- LastLocalChangeTime — datetime
- ComplianceCRC — varbinary(4)
- rowversion — timestamp — NOT NULL
CM_Update_ScanStatus
- MachineID — int — NOT NULL
- UpdateSource_ID — int — NOT NULL
- ScanTime — datetime
- ScanPackageVersion — int
- LastScanState — int
- LastScanVersion — int
- LastScanTime — datetime
- LastLocation — nvarchar(512)
- LastStatusMessageID — int
- LastErrorCode — int
- LastLocalChangeTime — datetime
- rowversion — timestamp — NOT NULL
CM_uTmp_ColSync_HRGroup
- lv — int
- code — nvarchar(50)
- name — nvarchar(512)
- pcode — nvarchar(50)
- pname — nvarchar(512)
- desc — nvarchar(512)
CM_uTmp_ColSync_HRGroupMember
- groupID — nvarchar(100)
- member — nvarchar(100)
CM_user_disc
- ItemKey — int — NOT NULL
- DiscArchKey — int
- User_Name0 — nvarchar(256)
- Unique_User_Name0 — nvarchar(255)
- Network_Operating_System0 — nvarchar(256)
- Windows_NT_Domain0 — nvarchar(256)
- Full_Domain_Name0 — nvarchar(256)
- Name0 — nvarchar(256)
- SID0 — nvarchar(256)
- Object_GUID0 — varbinary(16)
- Full_User_Name0 — nvarchar(256)
- Creation_Date0 — datetime
- AD_Object_Creation_Time0 — datetime
- Primary_Group_ID0 — int
- User_Account_Control0 — int
- Mail0 — nvarchar(256)
- Distinguished_Name0 — nvarchar(256)
- User_Principal_Name0 — nvarchar(256)
- CloudUserID — uniqueidentifier
- AADTenantID — uniqueidentifier
- AADUserID — uniqueidentifier
- cn0 — nvarchar(32)
CM_v_Advertisement
- AdvertisementID — nvarchar(8)
- AdvertisementName — nvarchar(200)
- PackageID — nvarchar(8)
- ProgramName — nvarchar(100)
- CollectionID — nvarchar(8)
- Comment — nvarchar(512) — varchar(512) NUL
- IncludeSubCollection — int — NOT NULL
- HierarchyPath — nvarchar(255)
- AssignmentID — int
- AssignedScheduleEnabled — int
- PresentTime — datetime
- PresentTimeEnabled — int
- PresentTimeIsGMT — int
- ExpirationTime — datetime
- ExpirationTimeEnabled — int
- ExpirationTimeIsGMT — int
- TimeFlags — int
- AdvertFlags — int
- DeviceFlags — int
- RemoteClientFlags — int
- Priority — int
- SourceSite — nvarchar(3)
- ActionInProgress — int — NOT NULL
CM_v_AdvertisementInfo
- AdvertisementID — nvarchar(8)
- AdvertisementName — nvarchar(200)
- PackageID — nvarchar(8)
- ProgramName — nvarchar(100)
- CollectionID — nvarchar(8)
- PresentTime — datetime
- TimeFlags — int
- ExpirationTime — datetime
- AdvertisementSourceSite — nvarchar(3)
- PackageName — nvarchar(256)
- PackageVersion — nvarchar(64)
- PackageLanguage — nvarchar(64)
- PackageManufacturer — nvarchar(64)
- CollectionName — nvarchar(255)
- ProgramFlags — int
CM_v_AdvertisementStatusInformation
- MessageID — int
- MessageState — int — NOT NULL
- MessageStateName — nvarchar(255)
- MessageName — nvarchar(512)
CM_v_AgentDiscoveries
- ResourceType — int — NOT NULL
- ResourceId — int — NOT NULL
- AgentName — nvarchar(50)
- AgentSite — nvarchar(3)
- AgentTime — datetime
CM_v_ApplicationAssignment
- AssignmentID — int — NOT NULL
- Assignment_UniqueID — nvarchar(38)
- AssignmentName — nvarchar(256)
- Description — nvarchar(512)
- LocalCollectionID — int — NOT NULL
- CollectionID — nvarchar(8)
- CollectionName — nvarchar(255)
- IncludeSubCollections — int — NOT NULL
- DesiredConfigType — int — NOT NULL
- AssignmentAction — int — NOT NULL
- NonComplianceCriticality — int
- DPLocality — int — NOT NULL
- LogComplianceToWinEvent — bit — NOT NULL
- SendDetailedNonComplianceStatus — bit — NOT NULL
- SuppressReboot — int — NOT NULL
- NotifyUser — bit — NOT NULL
- UseGMTTimes — bit — NOT NULL
- CreationTime — datetime — NOT NULL
- ExpirationTime — datetime
- StartTime — datetime — NOT NULL
- EnforcementDeadline — datetime
- SoftDeadlineEnabled — bit — NOT NULL
- LastModificationTime — datetime — NOT NULL
- LastModifiedBy — nvarchar(512)
- UpdateDeadlineTime — datetime
- EvaluationSchedule — nvarchar(255)
- OverrideServiceWindows — bit
- RebootOutsideOfServiceWindows — bit
- SourceSite — nvarchar(3)
- AssignmentType — int — NOT NULL
- Priority — int
- OfferTypeID — int
- OfferFlags — int
- RequireApproval — bit
- UpdateSupersedence — bit — NOT NULL
- LocaleID — int — NOT NULL
- WoLEnabled — bit
- RaiseMomAlertsOnFailure — bit
- DisableMomAlerts — bit
- EnforcementEnabled — bit
- rowversion — timestamp — NOT NULL
- ContainsExpiredUpdates — bit — NOT NULL
- TargetCollectionSiteID — nvarchar(8)
- UserUIExperience — bit
- AssignmentEnabled — bit
- LimitStateMessageVerbosity — bit
- StateMessageVerbosity — tinyint
- StateMessagePriority — int
- PersistOnWriteFilterDevices — bit
- AssignedCI_UniqueID — nvarchar(300)
- ApplicationName — nvarchar(513)
- AppModelID — int
CM_v_AuthListInfo
- CI_ID — int — NOT NULL
- CI_UniqueID — nvarchar(300)
- ModelId — int — NOT NULL
- ModelName — nvarchar(300)
- SDMPackageVersion — int — NOT NULL
- SDMPackageDigest — xml
- CIType_ID — int — NOT NULL
- CIVersion — int — NOT NULL
- DateCreated — datetime — NOT NULL
- DateLastModified — datetime
- LastModifiedBy — nvarchar(512)
- CreatedBy — nvarchar(512)
- PermittedUses — int — NOT NULL
- IsBundle — bit — NOT NULL
- IsHidden — bit — NOT NULL
- IsTombstoned — bit — NOT NULL
- IsUserDefined — bit — NOT NULL
- IsEnabled — bit — NOT NULL
- IsExpired — bit — NOT NULL
- SourceSite — nvarchar(3)
- ContentSourcePath — nvarchar(512)
- ApplicabilityCondition — nvarchar(512)
- CI_CRC — nvarchar(8)
- Precedence — int
- ConfigurationFlags — bigint
- EULAExists — int — NOT NULL
- EULAAccepted — tinyint — NOT NULL
- EULASignoffDate — datetime
- EULASignoffUser — nvarchar(512)
- IsQuarantined — int — NOT NULL
- EffectiveDate — int
- ModifiedTime — int
- IsDeployed — int — NOT NULL
- IsSuperseded — int — NOT NULL
- IsChild — int — NOT NULL
- InUse — int — NOT NULL
- IsLatest — bit — NOT NULL
- IsBroken — int — NOT NULL
- PlatformType — int — NOT NULL
- IsUserCI — int — NOT NULL
- RevisionTag — varbinary(64)
- IsSignificantRevision — int — NOT NULL
- SedoObjectVersion — nvarchar(56)
- ApplicableAtUserLogon — bit
- LocaleID — int
- Title — nvarchar(513)
- Description — nvarchar(3000)
- InfoURL — nvarchar(512)
CM_v_CH_ClientSummary
- ResourceID — int — NOT NULL
- LastOnline — datetime
- LastMPServerName — nvarchar(256)
- LastDDR — datetime
- LastHW — datetime
- LastSW — datetime
- LastStatusMessage — datetime
- LastPolicyRequest — datetime
- LastHealthEvaluation — datetime
- LastHealthEvaluationResult — smallint
- IsActiveDDR — int — NOT NULL
- IsActiveHW — int — NOT NULL
- IsActiveSW — int — NOT NULL
- IsActivePolicyRequest — int — NOT NULL
- IsActiveStatusMessages — int — NOT NULL
- LastEvaluationHealthy — int — NOT NULL
- ClientRemediationSuccess — int
- LastActiveTime — datetime
- ClientActiveStatus — int — NOT NULL
- ClientState — int
- ClientStateDescription — varchar(16)
- ExpectedNextPolicyRequest — datetime
- AADDeviceID — uniqueidentifier
CM_v_CIAssignment
- AssignmentID — int — NOT NULL
- Assignment_UniqueID — nvarchar(38)
- AssignmentName — nvarchar(256)
- Description — nvarchar(512)
- LocalCollectionID — int — NOT NULL
- CollectionID — nvarchar(8)
- CollectionName — nvarchar(255)
- IncludeSubCollections — int — NOT NULL
- DesiredConfigType — int — NOT NULL
- AssignmentAction — int — NOT NULL
- NonComplianceCriticality — int
- DPLocality — int — NOT NULL
- LogComplianceToWinEvent — bit — NOT NULL
- SendDetailedNonComplianceStatus — bit — NOT NULL
- SuppressReboot — int — NOT NULL
- NotifyUser — bit — NOT NULL
- UseGMTTimes — bit — NOT NULL
- CreationTime — datetime — NOT NULL
- ExpirationTime — datetime
- StartTime — datetime — NOT NULL
- EnforcementDeadline — datetime
- SoftDeadlineEnabled — bit — NOT NULL
- LastModificationTime — datetime — NOT NULL
- LastModifiedBy — nvarchar(512)
- UpdateDeadlineTime — datetime
- EvaluationSchedule — nvarchar(255)
- OverrideServiceWindows — bit
- RebootOutsideOfServiceWindows — bit
- SourceSite — nvarchar(3)
- AssignmentType — int — NOT NULL
- Priority — int
- OfferTypeID — int
- OfferFlags — int
- RequireApproval — bit
- UpdateSupersedence — bit — NOT NULL
- LocaleID — int — NOT NULL
- WoLEnabled — bit
- RaiseMomAlertsOnFailure — bit
- DisableMomAlerts — bit
- EnforcementEnabled — bit
- UserUIExperience — bit
- AssignmentEnabled — bit
- LimitStateMessageVerbosity — bit
- StateMessageVerbosity — tinyint
- StateMessagePriority — int
- UseBranchCache — bit
- RequirePostRebootFullScan — bit — NOT NULL
- RandomizationEnabled — bit
- RandomizationMinutes — int
- PersistOnWriteFilterDevices — bit
- ParentAssignmentID — int
- rowversion — timestamp — NOT NULL
CM_v_CIAssignmentTargetedMachines
- AssignmentID — int — NOT NULL
- ResourceID — int — NOT NULL
CM_v_CIAssignmentToCI
- AssignmentID — int — NOT NULL
- CI_ID — int — NOT NULL
CM_v_CICurrentComplianceStatus
- CI_ID — int — NOT NULL
- CI_UniqueID — nvarchar(300)
- CIType_ID — int — NOT NULL
- ResourceID — int — NOT NULL
- ModelId — int — NOT NULL
- UserID — int — NOT NULL
- UserName — nvarchar(512)
- FullName — nvarchar(544)
- ModelName — nvarchar(300)
- CIVersion — int — NOT NULL
- SDMPackageVersion — int — NOT NULL
- IsApplicable — bit
- IsDetected — bit
- DesiredState — tinyint — NOT NULL
- ComplianceState — tinyint — NOT NULL
- IsEnforced — bit
- ComplianceValidationRuleFailures — smallint
- ErrorCount — int
- ConflictCount — int
- LastComplianceMessageTime — datetime
- MaxNoncomplianceCriticality — tinyint
- ReificationCount — int
- CompliantRulesCount — int
- EnforcementState — smallint
- LastEnforcementMessageTime — datetime
- LastErrorCode — int
- CI_CurrentComplianceStatusID — bigint — NOT NULL
CM_v_CIRelation
- FromCIID — int — NOT NULL
- ToCIID — int — NOT NULL
- RelationType — int — NOT NULL
- IsVersionSpecific — bit — NOT NULL
- IsBroken — bit — NOT NULL
- Priority — int
CM_v_ClientAdvertisementStatus
- AdvertisementID — nvarchar(8)
- ResourceID — int — NOT NULL
- LastAcceptanceMessageIDSeverity — int
- LastAcceptanceMessageID — int
- LastAcceptanceMessageIDName — nvarchar(512)
- LastAcceptanceState — int
- LastAcceptanceStateName — nvarchar(255)
- LastAcceptanceStatusTime — datetime
- LastStatusMessageIDSeverity — int
- LastStatusMessageID — int
- LastStatusMessageIDName — nvarchar(512)
- LastState — int
- LastStateName — nvarchar(255)
- LastStatusTime — datetime
- LastExecutionResult — nvarchar(1024)
- LastExecutionContext — nvarchar(255)
- IsActive — int
CM_v_ClientCollectionMembers
- CollectionID — nvarchar(8)
- ResourceID — int — NOT NULL
- Name — nvarchar(255)
- Domain — nvarchar(255)
- SiteCode — nvarchar(3)
- IsClient — bit — NOT NULL
CM_v_ClientMachines
- ResourceID — int — NOT NULL
- Name — nvarchar(255)
- Domain — nvarchar(255)
- SiteCode — nvarchar(3)
- IsClient — bit — NOT NULL
CM_v_Collection
- CollectionID — nvarchar(8)
- Name — nvarchar(255)
- Comment — nvarchar(512) — varchar(512) NUL
- LastChangeTime — datetime
- EvaluationStartTime — datetime
- LastRefreshTime — datetime
- RefreshType — int
- CollectionType — int — NOT NULL
- CurrentStatus — int — NOT NULL
- MemberCount — int — NOT NULL
- MemberClassName — nvarchar(30)
- LastMemberChangeTime — datetime
- CollID — int — NOT NULL
CM_v_ComponentSummarizer
- Status — int
- SiteCode — nvarchar(3)
- MachineName — nvarchar(255)
- ComponentName — nvarchar(295)
- State — int
- Type — int
- NextScheduledTime — datetime
- LastStarted — datetime
- LastContacted — datetime
- Infos — int
- Warnings — int
- Errors — int
- TallyInterval — nvarchar(16)
- ComponentType — nvarchar(64)
- LastHeartbeat — datetime
- HeartbeatInterval — int
- AvailabilityState — int
CM_v_FullCollectionMembership
- CollectionID — nvarchar(8)
- ResourceID — int — NOT NULL
- ResourceType — tinyint — NOT NULL
- Name — nvarchar(255)
- Domain — nvarchar(255)
- SMSID — nvarchar(255)
- SiteCode — nvarchar(3)
- IsDirect — bit — NOT NULL
- IsAssigned — bit — NOT NULL
- IsClient — int — NOT NULL
- ClientType — int
- IsObsolete — int
- IsActive — int
- IsDecommissioned — int — NOT NULL
- IsVirtualMachine — bit
- AMTStatus — int
- DeviceOwner — int
- DeviceCategory — nvarchar(80)
- AMTFullVersion — nvarchar(256)
- SuppressAutoProvision — bit
- IsApproved — int
- IsBlocked — bit
- IsAlwaysInternet — bit
- IsInternetEnabled — bit
- ClientCertType — int
- IsMachineChangesPersisted — bit
- IsMachineAssignedToUser — bit
- VMHostName — nvarchar(256)
- rowversion — timestamp
- Priority — int
CM_v_GS_ADD_REMOVE_PROGRAMS
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- DisplayName0 — nvarchar(255)
- InstallDate0 — nvarchar(255)
- ProdID0 — nvarchar(255)
- Publisher0 — nvarchar(255)
- Version0 — nvarchar(255)
CM_v_GS_COMPUTER_SYSTEM
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- AdminPasswordStatus0 — int
- AutomaticResetBootOption0 — int
- AutomaticResetCapability0 — int
- BootOptionOnLimit0 — int
- BootOptionOnWatchDog0 — int
- BootROMSupported0 — int
- BootupState0 — nvarchar(255)
- Caption0 — nvarchar(255)
- ChassisBootupState0 — int
- CurrentTimeZone0 — int
- DaylightInEffect0 — int
- Description0 — nvarchar(255)
- Domain0 — nvarchar(255)
- DomainRole0 — int
- FrontPanelResetStatus0 — int
- InfraredSupported0 — int
- InitialLoadInfo0 — nvarchar(255)
- InstallDate0 — datetime
- KeyboardPasswordStatus0 — int
- LastLoadInfo0 — nvarchar(255)
- Manufacturer0 — nvarchar(255)
- Model0 — nvarchar(255)
- Name0 — nvarchar(255)
- NameFormat0 — nvarchar(255)
- NetworkServerModeEnabled0 — int
- NumberOfProcessors0 — int
- OEMLogoBitmap0 — nvarchar(255)
- OEMStringArray0 — nvarchar(255)
- PauseAfterReset0 — nvarchar(255)
- PowerManagementCapabilities0 — nvarchar(255)
- PowerManagementSupported0 — int
- PowerOnPasswordStatus0 — int
- PowerState0 — int
- PowerSupplyState0 — int
- PrimaryOwnerContact0 — nvarchar(255)
- PrimaryOwnerName0 — nvarchar(255)
- ResetCapability0 — int
- ResetCount0 — int
- ResetLimit0 — int
- Roles0 — nvarchar(255)
- Status0 — nvarchar(255)
- SupportContactDescription0 — nvarchar(255)
- SystemStartupDelay0 — int
- SystemStartupOptions0 — nvarchar(255)
- SystemStartupSetting0 — int
- SystemType0 — nvarchar(255)
- ThermalState0 — int
- TotalPhysicalMemory0 — bigint
- UserName0 — nvarchar(255)
- WakeUpType0 — int
CM_v_GS_DISK
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- Availability0 — int
- BytesPerSector0 — int
- Capabilities0 — nvarchar(255)
- CapabilityDescriptions0 — nvarchar(255)
- Caption0 — nvarchar(255)
- CompressionMethod0 — nvarchar(255)
- ConfigManagerErrorCode0 — int
- ConfigManagerUserConfig0 — int
- DefaultBlockSize0 — bigint
- Description0 — nvarchar(255)
- DeviceID0 — nvarchar(255)
- ErrorCleared0 — int
- ErrorDescription0 — nvarchar(255)
- ErrorMethodology0 — nvarchar(255)
- Index0 — int
- InstallDate0 — datetime
- InterfaceType0 — nvarchar(255)
- LastErrorCode0 — int
- Manufacturer0 — nvarchar(255)
- MaxBlockSize0 — bigint
- MaxMediaSize0 — bigint
- MediaLoaded0 — int
- MediaType0 — nvarchar(255)
- MinBlockSize0 — bigint
- Model0 — nvarchar(255)
- Name0 — nvarchar(255)
- NeedsCleaning0 — int
- NumberOfMediaSupported0 — int
- Partitions0 — int
- PNPDeviceID0 — nvarchar(255)
- PowerManagementCapabilities0 — nvarchar(255)
- PowerManagementSupported0 — int
- SCSIBus0 — int
- SCSILogicalUnit0 — int
- SCSIPort0 — int
- SCSITargetId0 — int
- SectorsPerTrack0 — int
- Size0 — bigint
- Status0 — nvarchar(255)
- StatusInfo0 — int
- SystemName0 — nvarchar(255)
- TotalCylinders0 — nvarchar(255)
- TotalHeads0 — int
- TotalSectors0 — nvarchar(255)
- TotalTracks0 — nvarchar(255)
- TracksPerCylinder0 — int
CM_v_GS_NETWORK_ADAPTER
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- AdapterType0 — nvarchar(255)
- AutoSense0 — int
- Availability0 — int
- Caption0 — nvarchar(255)
- ConfigManagerErrorCode0 — int
- ConfigManagerUserConfig0 — int
- Description0 — nvarchar(255)
- DeviceID0 — nvarchar(255)
- ErrorCleared0 — int
- ErrorDescription0 — nvarchar(255)
- Index0 — int
- InstallDate0 — datetime
- Installed0 — int
- LastErrorCode0 — int
- MACAddress0 — nvarchar(255)
- Manufacturer0 — nvarchar(255)
- MaxNumberControlled0 — int
- MaxSpeed0 — nvarchar(255)
- Name0 — nvarchar(255)
- NetworkAddresses0 — nvarchar(255)
- PermanentAddress0 — nvarchar(255)
- PNPDeviceID0 — nvarchar(255)
- PowerManagementCapabilities0 — nvarchar(255)
- PowerManagementSupported0 — int
- ProductName0 — nvarchar(255)
- ServiceName0 — nvarchar(255)
- Speed0 — nvarchar(255)
- Status0 — nvarchar(255)
- StatusInfo0 — int
- SystemName0 — nvarchar(255)
- TimeOfLastReset0 — datetime
CM_v_GS_NETWORK_ADAPTER_CONFIGUR
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- ArpAlwaysSourceRoute0 — int
- ArpUseEtherSNAP0 — int
- Caption0 — nvarchar(255)
- DatabasePath0 — nvarchar(255)
- DeadGWDetectEnabled0 — int
- DefaultIPGateway0 — nvarchar(255)
- DefaultTOS0 — int
- DefaultTTL0 — int
- Description0 — nvarchar(255)
- DHCPEnabled0 — int
- DHCPLeaseExpires0 — datetime
- DHCPLeaseObtained0 — datetime
- DHCPServer0 — nvarchar(255)
- DNSDomain0 — nvarchar(255)
- DNSDomainSuffixSearchOrder0 — nvarchar(255)
- DNSEnabledForWINSResolution0 — int
- DNSHostName0 — nvarchar(255)
- DNSServerSearchOrder0 — nvarchar(255)
- DomainDNSRegistrationEnabled0 — int
- ForwardBufferMemory0 — int
- FullDNSRegistrationEnabled0 — int
- GatewayCostMetric0 — nvarchar(255)
- IGMPLevel0 — int
- Index0 — int
- IPAddress0 — nvarchar(255)
- IPConnectionMetric0 — int
- IPEnabled0 — int
- IPFilterSecurityEnabled0 — int
- IPPortSecurityEnabled0 — int
- IPSecPermitIPProtocols0 — nvarchar(255)
- IPSecPermitTCPPorts0 — nvarchar(255)
- IPSecPermitUDPPorts0 — nvarchar(255)
- IPSubnet0 — nvarchar(255)
- IPUseZeroBroadcast0 — int
- IPXAddress0 — nvarchar(255)
- IPXEnabled0 — int
- IPXFrameType0 — nvarchar(255)
- IPXMediaType0 — int
- IPXNetworkNumber0 — nvarchar(255)
- IPXVirtualNetNumber0 — nvarchar(255)
- KeepAliveInterval0 — int
- KeepAliveTime0 — int
- MACAddress0 — nvarchar(255)
- MTU0 — int
- NumForwardPackets0 — int
- PMTUBHDetectEnabled0 — int
- PMTUDiscoveryEnabled0 — int
- ServiceName0 — nvarchar(255)
- SettingID0 — nvarchar(255)
- TcpipNetbiosOptions0 — int
- TcpMaxConnectRetransmissions0 — int
- TcpMaxDataRetransmissions0 — int
- TcpNumConnections0 — int
- TcpUseRFC1122UrgentPointer0 — int
- TcpWindowSize0 — int
- … +5
CM_v_GS_OPERATING_SYSTEM
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- BootDevice0 — nvarchar(255)
- BuildNumber0 — nvarchar(255)
- BuildType0 — nvarchar(255)
- Caption0 — nvarchar(255)
- CodeSet0 — nvarchar(255)
- CountryCode0 — nvarchar(255)
- CSDVersion0 — nvarchar(255)
- CurrentTimeZone0 — int
- Debug0 — int
- Description0 — nvarchar(255)
- Distributed0 — int
- ForegroundApplicationBoost0 — int
- FreePhysicalMemory0 — bigint
- FreeSpaceInPagingFiles0 — bigint
- FreeVirtualMemory0 — bigint
- InstallDate0 — datetime
- LastBootUpTime0 — datetime
- LocalDateTime0 — datetime
- Locale0 — nvarchar(255)
- Manufacturer0 — nvarchar(255)
- MaxNumberOfProcesses0 — int
- MaxProcessMemorySize0 — bigint
- MUILanguages0 — nvarchar(255)
- Name0 — nvarchar(255)
- NumberOfLicensedUsers0 — int
- NumberOfProcesses0 — int
- NumberOfUsers0 — int
- OperatingSystemSKU0 — int
- Organization0 — nvarchar(255)
- OSArchitecture0 — nvarchar(255)
- OSLanguage0 — int
- OSProductSuite0 — int
- OSType0 — int
- OtherTypeDescription0 — nvarchar(255)
- PlusProductID0 — nvarchar(255)
- PlusVersionNumber0 — nvarchar(255)
- Primary0 — int
- ProductType0 — int
- RegisteredUser0 — nvarchar(255)
- SerialNumber0 — nvarchar(255)
- ServicePackMajorVersion0 — int
- ServicePackMinorVersion0 — int
- SizeStoredInPagingFiles0 — bigint
- Status0 — nvarchar(255)
- SystemDevice0 — nvarchar(255)
- SystemDirectory0 — nvarchar(255)
- TotalSwapSpaceSize0 — bigint
- TotalVirtualMemorySize0 — bigint
- TotalVisibleMemorySize0 — bigint
- Version0 — nvarchar(255)
- WindowsDirectory0 — nvarchar(255)
CM_v_GS_PC_BIOS
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- BiosCharacteristics0 — nvarchar(255)
- BIOSVersion0 — nvarchar(255)
- BuildNumber0 — nvarchar(255)
- Caption0 — nvarchar(255)
- CodeSet0 — nvarchar(255)
- CurrentLanguage0 — nvarchar(255)
- Description0 — nvarchar(255)
- IdentificationCode0 — nvarchar(255)
- InstallableLanguages0 — int
- InstallDate0 — datetime
- LanguageEdition0 — nvarchar(255)
- ListOfLanguages0 — nvarchar(255)
- Manufacturer0 — nvarchar(255)
- Name0 — nvarchar(255)
- OtherTargetOS0 — nvarchar(255)
- PrimaryBIOS0 — int
- ReleaseDate0 — datetime
- SerialNumber0 — nvarchar(255)
- SMBIOSBIOSVersion0 — nvarchar(255)
- SMBIOSMajorVersion0 — int
- SMBIOSMinorVersion0 — int
- SMBIOSPresent0 — int
- SoftwareElementID0 — nvarchar(255)
- SoftwareElementState0 — int
- Status0 — nvarchar(255)
- TargetOperatingSystem0 — int
- Version0 — nvarchar(255)
CM_v_GS_PHYSICAL_MEMORY
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- BankLabel0 — nvarchar(255)
- Capacity0 — bigint
- Caption0 — nvarchar(255)
- CreationClassName0 — nvarchar(255)
- DataWidth0 — int
- Description0 — nvarchar(255)
- DeviceLocator0 — nvarchar(255)
- FormFactor0 — int
- HotSwappable0 — int
- InstallDate0 — datetime
- InterleaveDataDepth0 — int
- InterleavePosition0 — int
- Manufacturer0 — nvarchar(255)
- MemoryType0 — int
- Model0 — nvarchar(255)
- Name0 — nvarchar(255)
- OtherIdentifyingInfo0 — nvarchar(255)
- PartNumber0 — nvarchar(255)
- PositionInRow0 — int
- PoweredOn0 — int
- Removable0 — int
- Replaceable0 — int
- SerialNumber0 — nvarchar(255)
- SKU0 — nvarchar(255)
- Speed0 — int
- Status0 — nvarchar(255)
- Tag0 — nvarchar(255)
- TotalWidth0 — int
- TypeDetail0 — int
- Version0 — nvarchar(255)
CM_v_GS_SERVICE
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- AcceptPause0 — int
- AcceptStop0 — int
- Caption0 — nvarchar(255)
- CheckPoint0 — int
- Description0 — nvarchar(255)
- DesktopInteract0 — int
- DisplayName0 — nvarchar(255)
- ErrorControl0 — nvarchar(255)
- ExitCode0 — int
- InstallDate0 — datetime
- Name0 — nvarchar(255)
- PathName0 — nvarchar(255)
- ProcessId0 — int
- ServiceSpecificExitCode0 — int
- ServiceType0 — nvarchar(255)
- Started0 — int
- StartMode0 — nvarchar(255)
- StartName0 — nvarchar(255)
- State0 — nvarchar(255)
- Status0 — nvarchar(255)
- SystemName0 — nvarchar(255)
- TagId0 — int
- WaitHint0 — int
CM_v_GS_SYSTEM_ENCLOSURE
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- AudibleAlarm0 — int
- BreachDescription0 — nvarchar(255)
- CableManagementStrategy0 — nvarchar(255)
- Caption0 — nvarchar(255)
- ChassisTypes0 — nvarchar(255)
- CurrentRequiredOrProduced0 — int
- Description0 — nvarchar(255)
- HeatGeneration0 — int
- HotSwappable0 — int
- InstallDate0 — datetime
- LockPresent0 — int
- Manufacturer0 — nvarchar(255)
- Model0 — nvarchar(255)
- Name0 — nvarchar(255)
- NumberOfPowerCords0 — int
- OtherIdentifyingInfo0 — nvarchar(255)
- PartNumber0 — nvarchar(255)
- PoweredOn0 — int
- Removable0 — int
- Replaceable0 — int
- SecurityBreach0 — int
- SecurityStatus0 — int
- SerialNumber0 — nvarchar(255)
- ServiceDescriptions0 — nvarchar(255)
- ServicePhilosophy0 — nvarchar(255)
- SKU0 — nvarchar(255)
- SMBIOSAssetTag0 — nvarchar(255)
- Status0 — nvarchar(255)
- Tag0 — nvarchar(255)
- TypeDescriptions0 — nvarchar(255)
- Version0 — nvarchar(255)
- VisibleAlarm0 — int
CM_v_gs_Processor
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- AddressWidth0 — int
- Architecture0 — int
- Availability0 — int
- BrandID0 — int
- Caption0 — nvarchar(255)
- ConfigManagerErrorCode0 — int
- ConfigManagerUserConfig0 — int
- CPUHash0 — nvarchar(255)
- CPUKey0 — nvarchar(255)
- CpuStatus0 — int
- CurrentClockSpeed0 — int
- CurrentVoltage0 — int
- DataWidth0 — int
- Description0 — nvarchar(255)
- DeviceID0 — nvarchar(255)
- ErrorCleared0 — int
- ErrorDescription0 — nvarchar(255)
- ExtClock0 — int
- Family0 — int
- InstallDate0 — datetime
- Is64Bit0 — int
- IsHyperthreadCapable0 — int
- IsHyperthreadEnabled0 — int
- IsMobile0 — int
- IsTrustedExecutionCapable0 — int
- IsVitualizationCapable0 — int
- L2CacheSize0 — int
- L2CacheSpeed0 — int
- L3CacheSize0 — int
- L3CacheSpeed0 — int
- LastErrorCode0 — int
- Level0 — int
- LoadPercentage0 — int
- Manufacturer0 — nvarchar(255)
- MaxClockSpeed0 — int
- Name0 — nvarchar(255)
- NormSpeed0 — int
- NumberOfCores0 — int
- NumberOfLogicalProcessors0 — int
- OtherFamilyDescription0 — nvarchar(255)
- PartOfDomain0 — int
- PCache0 — int
- PNPDeviceID0 — nvarchar(255)
- PowerManagementCapabilities0 — nvarchar(255)
- PowerManagementSupported0 — int
- ProcessorId0 — nvarchar(255)
- ProcessorType0 — int
- Revision0 — int
- Role0 — nvarchar(255)
- SocketDesignation0 — nvarchar(255)
- Status0 — nvarchar(255)
- StatusInfo0 — int
- Stepping0 — nvarchar(255)
- SystemName0 — nvarchar(255)
- UniqueId0 — nvarchar(255)
- … +4
CM_v_gs_logical_disk
- ResourceID — int — NOT NULL
- GroupID — int — NOT NULL
- RevisionID — int — NOT NULL
- AgentID — int
- TimeStamp — datetime — NOT NULL
- Access0 — int
- Availability0 — int
- BlockSize0 — bigint
- Caption0 — nvarchar(255)
- Compressed0 — int
- ConfigManagerErrorCode0 — int
- ConfigManagerUserConfig0 — int
- Description0 — nvarchar(255)
- DeviceID0 — nvarchar(255)
- DriveType0 — int
- ErrorCleared0 — int
- ErrorDescription0 — nvarchar(255)
- ErrorMethodology0 — nvarchar(255)
- FileSystem0 — nvarchar(255)
- FreeSpace0 — bigint
- InstallDate0 — datetime
- LastErrorCode0 — int
- MaximumComponentLength0 — int
- MediaType0 — int
- Name0 — nvarchar(255)
- NumberOfBlocks0 — nvarchar(255)
- PNPDeviceID0 — nvarchar(255)
- PowerManagementCapabilities0 — nvarchar(255)
- PowerManagementSupported0 — int
- ProviderName0 — nvarchar(255)
- Purpose0 — nvarchar(255)
- Size0 — bigint
- Status0 — nvarchar(255)
- StatusInfo0 — int
- SupportsFileBasedCompression0 — int
- SystemName0 — nvarchar(255)
- VolumeName0 — nvarchar(255)
- VolumeSerialNumber0 — nvarchar(255)