Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 888197 - Last Review: October 27, 2006 - Revision: 2.3
The Microsoft Operations Manager 2005 WMI Provider returns FALSE when you query the IsAgent property of the MSFT_Computer class
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.
This problem occurs because
MSFT_Computer class returns FALSE for the
IsAgent property.
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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kbprb kbwinservperf kbmgmtservices kbtshoot KB888197 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate