How do I determine what licenses I have for each AppManager component and how many? (NETIQKB27673)

How do I determine which licenses I have for each AppManager component and how many of each component has been deployed?

AppManager comes with two default reports detailed below:

REPORTAM_COMPLIC: This report list the number of licenses entered via License Manager (with the split on types of server NT, Windows2000, Window2003, etc). But, this is report determines use based on jobs running on an agent machine. Licenses in AppManager are only considered in use if a particular running job is applied on a agent machine.

Example: One NT license will show in use if an NT_CPULoaded job is running on an agent machine. Zero licenses will be shown in use if no jobs are running, but NT objects have been discovered on a particular agent machine.

REPORTAM_COMPDEPLOY: This report shows the number of machines discovered per module. However, this report does not split up the different NT licensed products (professional, server, advanced server, and data center). To determine the individual number of discovered objects for each NT license please use the following steps:

1. Open SQL Server Query Analyzer, login as 'sa' or another SQL sysadmin account.
2. Select the Repository (QDB) from the drop down menu in the tool bar.
3. Type the following SQL query: 
   
   SELECT ISNULL(String1, 'Not Discovered') 'Windows/NT' , count(*) 'Number of Machines discovered' from object where RootMachineObjID = ObjID group by String1
   
4. Execute the SQL query by using F5 or the green arrow.

Formerly known as NETIQKB27673