EN
Dieser Inhalt ist in Ihrer Sprache leider nicht verfügbar. Im Folgenden finden Sie die englische Version.

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

Anzeigen: