Value

Displays a numeric value if a query returned with only one row and one column. The returned data is numeric in value.

Note

In PATROL for Microsoft SQL Server 9.6.20, it displays value even if you have more than one row and/or one column as long as the data on the first row and column is numeric.

 

BMC PATROL properties

Property

Default value

Application class

MSSQL_SERVER_CUSTOM_SQL

Command type

NA

Platform

All

Icon style

Graph

Unit

Number (#)

Border range

Undefined

Alarm1 range

Undefined

Alarm2 range

Undefined

Scheduling (poll time)

Inherited

Active at installation

Yes

Parameter type

Consumer

TrueSight/ BMC Helix Operations Management properties

Property

Default value

Monitor type

SQL query

Key Performance Indicator

No

Monitor for abnormalities

No

Graph by default

Yes

Availability

No

Response time

No

Normal distribution

No

Statistical

No

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*