Microsoft KB Archive/888197

= The Microsoft Operations Manager 2005 WMI Provider returns FALSE when you query the IsAgent property of the MSFT_Computer class =

Article ID: 888197

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-





SYMPTOMS
When you query the IsAgent property of the MSFT_Computer class, the Microsoft Operations Manager (MOM) 2005 Windows Management Instrumentation (WMI) Provider always returns FALSE, although there are MOM agent computers on the corresponding MOM server.



CAUSE
This problem occurs because MSFT_Computer class returns FALSE for the IsAgent property.



WORKAROUND
To work around this problem, you must modify the Microsoft SQL Server view that is named MSFT_Computer. To do this, follow these steps:  Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. In the SQL Server box, type the name of the Microsoft SQL Server where the OnePoint database is installed, type the logon credentials, and then click OK. On the toolbar, click OnePoint in the list of databases.  Paste the following SQL statements into the Query - ServerName - Untitled1 pane, click Query, and then click Execute: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

ALTER VIEW dbo.MSFT_Computer  WITH VIEW_METADATA AS SELECT idComputer AS GUID, Name AS Name, Description AS Description, [Domain] AS Domain, DNSName AS DNSName, NULLIF(Type, NULL) AS Type, (CASE dbo.Computer.ManagedType WHEN 2 THEN 1 ELSE 0 END) AS IsAgent, NULLIF(IsCollector, NULL) AS IsConsolidator, LastHeartbeat AS TimeLastContacted, NULLIF(TimeAdded, NULL) AS TimeAdded, NULLIF(LastModified, NULL) AS TimeLastModified, LastModifiedBy AS LastModifiedBy FROM  dbo.Computer GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO 



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
After you modify the MSFT_Computer view in the OnePoint database, the MOM 2005 WMI Provider will appropriately return a TRUE or a FALSE for the IsAgent property, depending on whether the computer is an agent or not when you query the MSFT_Computer class.

Keywords: kbprb kbwinservperf kbmgmtservices kbtshoot KB888197

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.