Resolved! Custom report for systems with multiple IP addresses
Ok, I was able to piece together a report that is 99% of what I need, but I have the occasional duplicate entry when the coalesced field returns different values (single IP vs. multiple IPs).Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.A...