SCRM 2006 Stored Procedures

System Center

SCRM 2006 report filters use the following stored procedures to get data from the SCRM data warehouse.

In This Section

SCRS_GetAdvertisementProgramName Stored Procedure

Gets a list of SMS program names for an SMS advertisement.
SCRS_GetAlertNameByAlertSeverity Stored Procedure

Gets the list of MOM alerts.
SCRS_GetAlertSeverity Stored Procedure

Gets a list of alert severities with optional <ALL> member.
SCRS_GetAlertSeverity_List Stored Procedure

Gets a list of alert severities.
SCRS_GetAmountofTime Stored Procedure

Gets weekly representation of a time span calculated in days.
SCRS_GetApplicationName Stored Procedure

Gets the list of Add Remove Program display names.
SCRS_GetApplicationName1 Stored Procedure

Gets a list of application display names matching a string pattern.
SCRS_GetApplicationName2 Stored Procedure

Gets a list of application display names matching a string pattern and excluding a specific member.
SCRS_GetApplicationName3 Stored Procedure

Gets a list of application display names matching a string pattern and excluding two specific members.
SCRS_GetApplicationNameVersion Stored Procedure

Gets the list of versions of an application using its Add Remove Program display name.
SCRS_GetApplicationNameVersion1 Stored Procedure

Gets the list of versions of an application using its Add Remove Program display name and excluding a specific member.
SCRS_GetApplicationNameVersion2 Stored Procedure

Gets the list of versions of an application using its Add Remove Program display name and excluding two specific members.
SCRS_GetApplicationNameVersion3 Stored Procedure

Gets the list of versions of an application using its Add Remove Program display name and excluding three specific members.
SCRS_GetBulletinID Stored Procedure

Gets a list of software update bulletin identifiers using its scan type.
SCRS_GetCCComputerName Stored Procedure

Gets a list of full Windows NT computer names.
SCRS_GetChangeTypes Stored Procedure

Gets change types for a computer.
SCRS_GetCollectionName Stored Procedure

Gets a list of collections.
SCRS_GetCompany Stored Procedure

Gets a list of company names.
SCRS_GetComponentNameForSWD Stored Procedure

Gets the software distribution component name.
SCRS_GetComputerGroup Stored Procedure

Gets the list of groups associated with computers.
SCRS_GetComputerOwner Stored Procedure

Gets the list of users that own computers.
SCRS_GetComputerType Stored Procedure

Gets the computer type associated with a managed node.
SCRS_GetCostcenter Stored Procedure

Gets the list of cost centers associated with users.
SCRS_GetCPUSpeed Stored Procedure

Gets the CPU speed for a computer.
SCRS_GetDiskSizeArray Stored Procedure

Gets an array of disk sizes for the installed hard disks.
SCRS_GetDomain Stored Procedure

Gets a list of domains.
SCRS_GetDomainforSMSandMOM Stored Procedure

Gets the domain names for the SMS and MOM server computers.
SCRS_GetFreeSpace Stored Procedure

Gets the free disk space for a computer.
SCRS_GetFreeSpaceArray Stored Procedure

Gets an array of free disk space, for the installed hard disks (MB).
SCRS_GetFullComputerName Stored Procedure

Gets the full Windows computer name for a computer.
SCRS_GetFullComputerName_Search Stored Procedure

Gets the fully qualified computer names based on the supplied search criteria.
SCRS_GetHostType Stored Procedure

Gets the type of the computer. It can be physical.
SCRS_GetHWUpdate Stored Procedure

Gets a list of node change types.
SCRS_GetLanguage Stored Procedure

Gets a list of languages associated with managed nodes installed on the operating system.
SCRS_GetLanguageForLanguageID Stored Procedure

Gets the language for a supplied language identifier.
SCRS_GetLastRefreshDate Stored Procedure

Last SMS source data synchronization date.
SCRS_GetLocalizedCommonString Stored Procedure

Provides a localized value for a random list of otherwise hard-coded words that appear throughout the data.
SCRS_GetLocalizedComputerType Stored Procedure

Provides a localized value for a computer type.
SCRS_GetLocation Stored Procedure

Gets the location of a computer.
SCRS_GetManager Stored Procedure

Gets a user's manager.
SCRS_GetManufacturer Stored Procedure

Gets the software manufacturer.
SCRS_GetMemory Stored Procedure

Gets the size of the physical memory installed on a computer.
SCRS_GetMemoryWithLabel Stored Procedure

Gets the total physical memory for computers.
SCRS_GetModel Stored Procedure

Gets the list of models for a specified manufacturer.
SCRS_GetMOMFullComputerName Stored Procedure

Gets the full computer name of a MOM computer.
SCRS_GetMOMFullComputerName_Search Stored Procedure

Gets the full computer name of a MOM computer based on the supplied search criteria.
SCRS_GetMOMFullComputerName_Second Stored Procedure

Gets a list of computer names excluding the specific name provided.
SCRS_GetMOMFullComputerName_Second_Search Stored Procedure

Gets a list of computer names matching the specified pattern but excluding the specified value, based on the supplied search criteria.
SCRS_GetMOMLastRefreshDate Stored Procedure

Gets the last refresh date for the MOM data source.
SCRS_GetOffice Stored Procedure

Gets a list of installed Microsoft Office products.
SCRS_GetOffice_SWCompliance Stored Procedure

Gets a list of Microsoft Office products for the compliance reporting outputs.
SCRS_GetOffice1 Stored Procedure

Gets the Microsoft Office installations that match a specific version.
SCRS_GetOffice2 Stored Procedure

Gets the Microsoft Office installations that match one of two versions.
SCRS_GetOffice3 Stored Procedure

Gets the Microsoft Office installations that match one of three versions.
SCRS_GetOfficeandVersion Stored Procedure

Gets the Microsoft Office version for a supplied description.
SCRS_GetOfficeandVersion_SWCompliance Stored Procedure

Gets the Microsoft Office versions that are compliant.
SCRS_GetOfficeandVersion1 Stored Procedure

Gets the installations of a specific Microsoft Office version.
SCRS_GetOfficeandVersion2 Stored Procedure

Gets the installations of two versions of Microsoft Office.
SCRS_GetOfficeandVersion3 Stored Procedure

Gets the installations on three versions of Microsoft office.
SCRS_GetOperatingSystem Stored Procedure

Gets the installed operating systems.
SCRS_GetOperatingSystem_SWCompliance Stored Procedure

Gets the installed operating systems that are compliant.
SCRS_GetOperatingSystemFirst Stored Procedure

Gets the list of all operating systems.
SCRS_GetOperatingSystemFirst1 Stored Procedure

Gets the installations of all operating systems that match a supplied version.
SCRS_GetOperatingSystemFirst2 Stored Procedure

Gets all installations of two operating system versions.
SCRS_GetOperatingSystemFirst3 Stored Procedure

Gets all installations of three operating system versions.
SCRS_GetOperatingSysVersion Stored Procedure

Gets the version of a supplied operating system.
SCRS_GetOSVersion Stored Procedure

Gets the version of a supplied operating system.
SCRS_GetOSwithVersion Stored Procedure

Gets all operating systems and their versions.
SCRS_GetPackageName Stored Procedure

Gets a list of SMS packages.
SCRS_GetProcessorNumber Stored Procedure

Gets the number of processors for a computer.
SCRS_GetProcessorNumberStandard Stored Procedure

Gets the number of processors for a computer.
SCRS_GetProcessorSpeedStandard Stored Procedure

Gets a list of processor speeds.
SCRS_GetProcessorSpeedWithLabel Stored Procedure

Gets a list of processor speeds with additional column for producing the report's label.
SCRS_GetProgramName Stored Procedure

Gets the list names of programs associated with the specified company.
SCRS_GetProgramNameForPublisher Stored Procedure

Gets the publisher names for all programs.
SCRS_GetProgramVersion Stored Procedure

Gets the version for a supplied program name.
SCRS_GetQNumbersForBulletinID Stored Procedure

Gets the Knowledge Base article numbers for a specific scan type and bulletin identifier.
SCRS_GetScanType Stored Procedure

Gets the list of scan types.
SCRS_GetServicePack Stored Procedure

Gets the list of captions for a given operating system.
SCRS_GetServicePack_SWCompliance Stored Procedure

Gets the list of captions for a given operating system with output used by compliance reporting.
SCRS_GetServicePack1 Stored Procedure

Gets a list of operating system captions matching the pattern of a specific version.
SCRS_GetServicePack2 Stored Procedure

Gets a list of operating system captions matching the pattern of two specific versions.
SCRS_GetServicePack3 Stored Procedure

Gets a list of operating system captions matching the pattern of three specific versions.
SCRS_GetSeverity Stored Procedure

Gets the severity of all alerts.
SCRS_GetSMSSiteCode Stored Procedure

Gets the SMS site code.
SCRS_GetSoftwareUpdateOption Stored Procedure

Gets the available software update options.
SCRS_GetStatusMessageIDForSeverityForSWD Stored Procedure

Gets the status message identifier for a supplied software distribution severity.
SCRS_GetStatusMessageIDForSWU Stored Procedure

Gets the status message identifier for software update.
SCRS_GetSWPublisher Stored Procedure

Gets the software publisher.
SCRS_GetTimeZoneInformation Stored Procedure

Returns offset for the server's time zone.
SCRS_GetTitleForBulletinIDAndQnumber Stored Procedure

Gets the software update title for a supplied scan type.
SCRS_GetTotalMemorySizeStandard Stored Procedure

Gets a list of memory sizes for selection.
SCRS_GetTotalPhysicalDiskSize Stored Procedure

Gets a list of disk sizes for selection.
SCRS_GetTotalPhysicalDiskSizeStandard Stored Procedure

Gets a list of disk sizes for selection.
SCRS_GetValuesForSoftwareUpdateOption Stored Procedure

Gets a list of SWU options: Qnumbers.
SCRS_GetValuesForSoftwareUpdateOptionALL Stored Procedure

Gets a list of SWU options: Qnumbers.
SCRS_GetVersion Stored Procedure

Gets the version of a supplied product.

See Also

Show: