IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3

MS SQL Services Detail attributes

The MS SQL Services Detail attribute group provides details about the services that make up the SQL Server.

Host Name The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in situations or for historical data collection.

Hub Timestamp The time when this data was inserted at the hub. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.

Originnode The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.

Sample Timestamp The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where:

MM	Month
DD	Day
YY	Year
HH	Hour
mm	Minute
SS	Second

For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.

Server The name of the SQL Server.

Service Name The service name for the SQL Server.

Service State Current® service state. The following values are also valid:

External value	Internal value
Stopped	0
Start Pending	1
Stop Pending	2
Running	3
Continue Pending	4
Pause Pending	5
Paused	6
Unknown	-1

Service Start Mode Defined start mode for the service. The following values are also valid:

External value	Internal value
Automatic	1
Manual	2
Disabled	3
Unknown	-1

Service Status Current service status. The following values are also valid:

External value	Internal value
OK	0
Error	1
Degraded	2
Unknown	3
Pred Fail	4
Starting	5
Stopping	6
Service	7

Service Type The service type for this service to the Microsoft SQL Server. The following values are also valid:

External value	Internal value
SQLServer	1
SQLAgent	2
DTC	3
Analysis_OLAP	4
Search	5
ADHelper	6
Browser	7
DTS	8
SQLWriter	9
Report	10
Distributed Replay Controller	11
Distributed Replay Client	12
Unknown	-1

Feedback