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

WORKAROUND

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
2. 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.
3. On the toolbar, click OnePoint in the list of databases.
4. 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