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)