Summarizer — Site System

The SMS_SiteSystemSummarizer class is a high-level view of the health of the site systems at a given site. It contains the status of the various SMS site systems. An instance of this class is created for every storage object (disk drive, database, and so on) used by SMS for every site system for the site.

Table B.81 Summarizer — Site System (SMS_SiteSystemSummarizer)

PropertyData typeExampleNotes
BytesFreesint3244412Indicates the amount of free (unused) storage space (in bytes) for the storage object. A negative value indicates that this information is currently unavailable.
BytesTotalsint3251200Indicates the maximum amount of storage space (in bytes) the storage object can contain. A negative value indicates that this information is currently unavailable.
DownSincedatetimeSee “Date and Time Formats” at the beginning of this appendix.This displays the date and time when the storage object was first found to be down (inaccessible). The storage object is considered down if the site server fails to connect to the storage object due to network problems, security problems, and so on. A null value means that the system is not down.
ObjectTypeuint321Indicates the type of object for which status is being reported.

Values are:
0 = NALPATH
1 = SQL_DB
2 = SQL_LOG
PercentFreesint3286Indicates the percentage of free storage space available on the storage object. A negative value indicates that this information is currently unavailable.

Table B.82 Summarizer — Site System (SMS_SiteSystemSummarizer)

PropertyData typeExampleNotes
Rolestring"distribution point"Key. Indicates the SMS site system role performed by the site system:

Values are:
client access point,
distribution point,
SQL Server,
software metering server,
component server,
site server.
SiteCode string"GRN"Indicates the three-letter site code for the site.
SiteObjectstringAppears as a lengthy string.Key. Indicates a Network Access Layer (NAL) path to a storage object that is one of the following:
1. A directory that contains files
2. The name of the database
3. The transaction log if the storage object is a database or transaction log.
SiteSystemstringAppears as a lengthy string.Key. Indicates the name of the computer containing the storage object.
Statusuint320Indicates the “health” (color) of the site’s associated icon in the SMS Administrator console.

Values are:
0 = GREEN (OK)
1 = YELLOW (Warning)
2 = RED (Critical)