Applications Manager - Pull an inventory of servers, ipaddress and device type
select AM_ManagedObject.DISPLAYNAME,AM_ManagedObject.TYPE,CollectData.TARGETADDRESS from AM_ManagedObject,AM_ManagedResourceType,CollectData where AM_ManagedObject.TYPE=AM_ManagedResourceType.RESOURCETYPE and AM_ManagedResourceType.RESOURCETYPE not in ('Node','Network') and CollectData.resourcename=AM_ManagedObject.resourcename order by AM_ManagedObject.DISPLAYNAME
Use the above query in SQL Query Analyzer to pull out an inventory report of servers along with their ipaddress