Would it be possible to get a query to pull the following information.

Computer Name

IP Address

Last Successful Scan Date

 

And then for each computer, I want to include the Monitor(s) that are hooked up to it and their "Monitor Type" and "Serial Number".

We have about 200 different facilities and we have a ton of hardware to track down. Knowing what computers a monitor is hooked up to at least gives us a location.