Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SCRM 2006 SMS Views
Collapse the table of content
Expand the table of content

SCRM 2006 SMS Views

System Center

The SCRM 2006 presentation database (SystemCenterPresentation) contains the following SQL views for the SMS data collected by SCRM 2006.

In This Section

SCRM 2006 SC_SiteHierarchy_BRIDGE_View

Maps a parent site to each of its child sites.
SCRM 2006 SC_Service_DIMENSION_View

Describes all of the Microsoft Win32 services that exist in the enterprise.
SCRM 2006 SC_ServiceInstallation_FACT_View

Describes which services have been installed on managed nodes in an enterprise.
SCRM 2006 SC_NodeUSBController_OUTRIGGER_View

Lists hardware inventory for the USB devices on a managed node.
SCRM 2006 SC_NodeTape_OUTRIGGER_View

Lists hardware inventory for the tape drives on a managed node.
SCRM 2006 SC_NodeSound_OUTRIGGER_View

Lists hardware inventory for the sound cards on a managed node.
SCRM 2006 SC_NodeSCSIController_OUTRIGGER_View

Lists hardware inventory for the SCSI controllers on a managed node.
SCRM 2006 SC_NodeNetworkClient_OUTRIGGER_View

Lists hardware inventory for the network clients on a managed node.
SCRM 2006 SC_NodeModem_OUTRIGGER_View

Lists hardware inventory for the modems on a managed node.
SCRM 2006 SC_NodeLogon_OUTRIGGER_View

Lists history of user logons for a managed node.
SCRM 2006 SC_NodeIDEController_OUTRIGGER_View

Lists hardware inventory for the IDE controllers for a managed node.
SCRM 2006 SC_NodeEnclosure_OUTRIGGER_View

Lists hardware inventory for the enclosures for a managed node.
SCRM 2006 SCRS_ManagedNode_Dimension_View

Lists all information about SMS managed computers.
SCRM 2006 SC_CollectionHierarchy_BRIDGE_View

Lists the relationship between a parent collection and every subcollection below it.
SCRM 2006 SCRS_User_Dimension_View

Lists all information about each user and each user group.
SCRM 2006 SCRS_Time_Dimension_View

Contains the Coordinated Universal Time (Greenwich Mean Time) time of day.
SCRM 2006 SCRS_StatusMessage_Dimension_View

Lists the unique status messages that can be raised by SMS.
SCRM 2006 SCRS_SoftwareUpdate_Fact_View

Describes software update applicability and distribution
SCRM 2006 SCRS_SoftwareUpdate_Dimension_View

Lists each software update distributable by SMS.
SCRM 2006 SCRS_SoftwareInventory_Fact_View

Describes which files have been installed on each managed node.
SCRM 2006 SCRS_SoftwareDistribution_Fact_View

Describes what software is targeted and which nodes the software is distributed to.
SCRM 2006 SCRS_SMSSite_Dimension_View

Lists information about each SMS site.
SCRM 2006 SCRS_Package_Dimension_View

Lists the SMS software packages that are available for software distribution across all SMS installations in the enterprise.
SCRM 2006 SCRS_NodeVideoController_OUTRIGGER_View

Lists hardware inventory for the video cards on a managed node.
SCRM 2006 SCRS_NodeSMSSystemRole_OUTRIGGER_View

Lists SMS system role information for a managed node.
SCRM 2006 SCRS_NodePartition_OUTRIGGER_View

Lists hardware inventory for the logical partitions on a managed node.
SCRM 2006 SCRS_NodeNetCard_OUTRIGGER_View

Lists hardware inventory for the network cards on a managed node.
SCRM 2006 SCRS_NodeMonitor_OUTRIGGER_View

Lists hardware inventory for the video monitors on a managed node.
SCRM 2006 SCRS_NodeLocation_Dimension_View

Lists location information for computers.
SCRM 2006 SCRS_NodeLocationAndAssociation_FACT_View

Lists the association between a Node, its location, and the SMS site and the user or computer owner
SCRM 2006 SCRS_NodeDisk_Outrigger_View

Lists hardware inventory for the disks for a managed node.
SCRM 2006 SCRS_NodeChange_Fact_View

Lists the managed node configuration changes.
SCRM 2006 SCRS_NodeChangeType_Dimension_View

Lists the types of changes that are recorded in the SC_NodeChange_FACT table.
SCRM 2006 SCRS_NodeCDROM_OUTRIGGER_View

Lists hardware inventory for the CD-ROM drives for a managed node.
SCRM 2006 SCRS_LogicalDisk_Dimension_View

Lists details of each logical disk on a managed node.
SCRM 2006 SCRS_LogicalDiskFreeSpace_Fact_View

Lists the free space and total size of each logical disk on each managed node.
SCRM 2006 SCRS_Lineage_Dimension_View

Lists the source of SMS data stored in an SCRM data warehouse
SCRM 2006 SCRS_Language_DIMENSION_View

Lists operating system locales and their hexadecimal and decimal codes.
SCRM 2006 SC_File_Dimension_View

Lists the unique files that are inventored by the SMS agent for Software Inventory.
SCRM 2006 SCRS_Date_Dimension_View

Lists both calendar and fiscal calendar information for each date.
SCRM 2006 SCRS_Collection_Dimension_View

Lists the SMS collections.
SCRM 2006 SCRS_CollectionMemberUser_FACT_VIEW

Lists the users and user groups that are members of each SMS collection.
SCRM 2006 SCRS_CollectionMemberNode_FACT_VIEW

Lists the managed nodes that are members of each SMS collection.
SCRM 2006 SCRS_Advertisement_Dimension_View

Lists information about each SMS advertisement.
SCRM 2006 SCRS_AddRemoveProgram_Fact_View

Lists the Add Remove Program (ARP) registered programs and the managed nodes they were installed on.
SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View

Lists the programs that are registered with the uninstall program feature.

See Also

Show:
© 2015 Microsoft