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