SCRM 2006 SC_Service_DIMENSION_View

SC_Service_DIMENSION_View describes all of the Win32 services that exist in the enterprise.

SC_Service_DIMENSION_View

Column	Type	Constraint	Description
ServiceKey	int	Not Null	Key that uniquely identifies each row in the SC_ServiceDimension_Table and allows a service to be associated with a product.
ServiceLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this service entry had been inserted into the SMS site database.
ServiceDisplayName	nvarchar	Null values allowed	Display name of the service reported by the Service Control Manager.
ServiceName	nvarchar	Not Null	Unique identifier of the service that indicates the functionality that is managed.
ServiceType	nvarchar	Null values allowed	Type of service provided to calling processes, using the following values: Kernel Driver File System Driver Adapter Recognizer Driver Own Process Share Process Interactive Process
ServiceStartName	nvarchar	Null values allowed	Account name under which a service runs. Depending on the service type, the account name may be in the form of DomainName\Username. The service process is logged by using one of the following two forms when it runs: For accounts belonging to the built-in domain, .\Username can be specified for ServiceStartName. For kernel or system-level drivers, ServiceStartName contains the driver object name (that is, \FileSystem\Rdr or \Driver\Xns) that the input and output (I/O) system uses to load the device driver. Additionally, if NULL is specified, the driver runs with a default object name created by the I/O system based on the service name—for example, DWDOM\Admin. For Windows XP, you can use UPN format (Username@DomainName) to specify the ServiceStartName. For Windows 2000, to change from a specified user to the LocalSystem account, use .\LocalSystem.

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures