SDKComputerView
SDKComputerView stores data about all the computers in the MOM database. This includes all computers with MOM agents and any computers running MOM components or the computer running SQL Server that is hosting the MOM database.
Note that the SDKComputerView in the Operations Database will not return computers that appear to be invalid, or deleted. The SDKComputerView included in the Reporting Database could return some computers that were not returned by the corresponding view in the Operations Database.
The following table describes the columns of this view.
Column | SQL Server type | Null values allowed? | Description |
---|---|---|---|
idComputer |
uniqueidentifier |
No |
A GUID identifying the computer. |
Name |
nvarchar(255) |
No |
The name of the computer. |
Description |
nvarchar(255) |
Yes |
The description of the computer. |
Domain |
nvarchar(100) |
Yes |
The name of the domain to which the computer belongs. |
DNSName |
nvarchar(512) |
Yes |
If applicable, the computer's DNS name. |
Type |
int |
No |
The type of the computer. The following values are used:
|
IsAgent |
bit |
No |
This field uses a deprecated data source. It should not be used when creating new queries. |
IsConsolidator |
bit |
No |
The flag indicating whether the computer is functioning as a MOM Consolidator. |
TimeLastContacted |
datetime |
Yes |
The time the computer last contacted MOM. |
Examples
The following example shows how to query SDKComputerView for the names of all MOM Consolidators. The result is sorted by name.
SELECT Name
FROM SDKComputerView
WHERE IsConsolidator=1
ORDER BY Name
Requirements
Platforms: Requires Windows 2000 Server or later
Version: Requires MOM 2000 SP1 or later
Database: OnePoint (MOM 2000 SP1 or later) or SystemCenterReporting (MOM 2004 or later)