How do I query the AppManager Repository for the names andOBJIDs? (NETIQKB3977)

  • 7703977
  • 02-Feb-2007
  • 16-Feb-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

How do I query the AppManager Repository for the names and object IDs of the AppManager Management Server and AppManager Managed Clients?

Resolution

To view object IDs by server name in the AppManager Repository:

  1. Open SQL Server Query Analyzer.
  2. Select the Repository (QDB).
  3. Type the following SQL query: 
              
              SELECT ObjID
              FROM Object
              WHERE Name = 'ServerName' 

              Where 'ServerName' is the name of the Server.
  4. Execute the SQL query by using F5 or the green arrow.

Additional Information

Formerly known as NETIQKB3977

You may also gather this infomation via the Operator Console by selecting the Object in question and pressing ALT + F8.