Applications Manager - Pull an inventory of servers, ipaddress and device type

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