SELECT-only account required. The SQL account used here must have read-only (SELECT) permission on the site database. This application never issues INSERT, UPDATE, DELETE, TRUNCATE, ALTER, CREATE or DROP statements against a Configuration Manager database, and never creates indexes on it.
Required SCCM Views
In demonstration mode these are listed for reference. When a connector is configured the dashboard probes each view with a read-only SELECT and reports any missing view or column.
| View | Required columns | Alternates if unavailable |
|---|---|---|
| v_R_System | ResourceID, Netbios_Name0, Client0, Obsolete0 | v_R_System_Valid |
| v_R_User | ResourceID, Unique_User_Name0 | — |
| v_FullCollectionMembership | ResourceID, CollectionID | v_ClientCollectionMembers |
| v_Collection | CollectionID, Name, CollectionType | v_Collections |
| v_UpdateInfo | CI_ID, ArticleID, BulletinID, Title, IsSuperseded, IsExpired, Severity | — |
| v_Update_ComplianceStatusAll | ResourceID, CI_ID, Status, LastStatusChangeTime | — |
| v_UpdateScanStatus | ResourceID, LastScanState, LastErrorCode, LastScanTime | — |
| v_CIAssignment | AssignmentID, AssignmentName, Assignment_UniqueID, CollectionID, StartTime, EnforcementDeadline | — |
| v_CIAssignmentToCI | AssignmentID, CI_ID | v_AssignmentTargetedCIs |
| v_CombinedDeviceResources | MachineID, Name, ClientState, LastPolicyRequest | — |
| v_DeploymentSummary | DeploymentID, NumberTotal, NumberSuccess, NumberErrors, NumberInProgress, NumberUnknown, NumberOther, SummarizationTime | — |
| v_StateNames | TopicType, StateID, StateName | — |
| v_GS_OPERATING_SYSTEM | ResourceID, Caption0, Version0 | — |
| v_GS_WORKSTATION_STATUS | ResourceID, LastHWScan | — |
| v_CH_ClientSummary | ResourceID, ClientActiveStatus, LastPolicyRequest | — |
| v_LocalizedCIProperties | CI_ID, DisplayName | — |
| v_CategoryInfo | CategoryInstanceID, CategoryInstanceName, CategoryTypeName | — |