I am trying to generate a report of all Assets that have a scanned IP. If I do a report of all assets 'IP address' is not a selectable field. Similarly, I can have the IP address field if I make a report on say CMDB > Servers or CMDB > Printers but not on CMDB > All Assets. 

Has anyone got any idea how I can get this information into a single report?

Thanks