This report is to answer a question on here, i have found the report useful so here to share 
This is a report that will show you all IP address used by IPAM and what IP address are using that subnet and if you have a node using that IP address it will appear in the Orion node column
below is the SQL query behind the scenes if you just want to copy and paste
select '<a href="' + '/Orion/IPAM/search.aspx?q=' + CAST(ipn.ipaddress AS varchar(256)) + '" style="font-size:100%">' + ipn.IPAddress + '</a>' AS 'IPAM IP Address' ,gv.Address as Subnet ,gv.Comments ,nrv.dnsbackward DNS ,nrv.ipstatus Status ,'<img src="/NetPerfMon/images/Small-'+n.StatusLED+'"/> ' + '<a href="' + '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:' + CAST(n.NodeID AS varchar(256)) + '" style="font-size:100%">' + n.Caption + '</a>' AS 'NODE' ,n.IP_Address Orion_IP ,'<img src="/NetPerfMon/Images/Vendors/' + n.VendorIcon + '"/> ' from IPAM_Node ipn join IPAM_GroupReportView gv with(nolock) on gv.SubnetID=ipn.SubnetId join IPAM_Group gp with(nolock) on gp.GroupId = gv.GroupId join IPAM_NodeReportView nrv with(nolock) on nrv.IPNodeId = ipn.IPNodeId left join nodes n with(nolock) on n.IP_Address = ipn.IPAddress where nrv.ipstatus not like 'Available'
many thanks
