SCRM 2006 Stored Procedures
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
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures