How do I generate a report by server of all the custom properties for each agent? (NETIQKB44142)

  • 7744142
  • 02-Feb-2007
  • 06-Jan-2011


NetIQ AppManager 6.x
NetIQ AppManager 7.0.x


How do I generate a report by server of all the custom properties for each agent?


Currently, AppManager (AM) does not have a Report detailing all custom server attributes.  However, you could use an SQL query against your Repository database (QDB by default) to return some custom attribute information. 

Warning!!!: This SQL Query directly accesses your database and updates/deletes data. If the query is performed incorrectly it can cause irreparable harm to the database and may result in loss of data. If you are unfamiliar with SQL or how to run a SQL Query please contact your SQL Database Administrator (DBA). Use of this query is at your own risk and is not bound by the coverage of NetIQ Technical Support.

select * from objectprop where objid = xxx

(where xxx could be 34)


  1. Right-click on a server in the Operator Console and select Custom Properties.
  2. Click New and assign your Custom Settings as detailed below:
    Name:     The name of the attribute you are entering
    Format:  String (no modifications)
    Value:      Enter the value or comment you wish
  3. Click OK.
  4. Run your query in SQL Query Analyzer. For example:

    select * from objectprop where name = 'name'

    Where 'name' is the Custom Setting you assigned in step one
  5. You should find results in the query analyzer window sorted by objid of the Server.

You could then use JOINS within your SQL command to return the actual machine name associated with that objid. While this is a modification of the original query (select * from objectprop where objid = xxxx), the same basic result is returned for the single objid you specified. Of course, the objid is found by selecting your server and using ALT+F8.

Additional Information

Formerly known as NETIQKB44142

Please note that Technical Support does not support custom queries. The information provided in this knowledge base article is provided as-is.  We strongly recommend that you run this query in a against a test AppManager database first. You should perform a full backup of the repository prior to running any queries.