Computer Detals report

[dwieszczak]

Could you provide me with the SQL report that would give me the details of each computer (ex: hostname, model, serial, procesor, memory, software installed, OS, domain, etc...) like the computer action screen but with software included. Thanks in advance.

[Hemoco]

This page does several sql queries to create the page (because you can't do it in one)

[dwieszczak]

What is the SQL query that runs when you do a searh for a computer and then click the computer report within the web user interface? This is the information I want in the report but I want a report per PC for all of my PC's, not just the one.

[Hemoco]

The problem is that you can't do this in one report because you will have multiple lines for each software item.
Everything else you want could be made in one report.

[dwieszczak]

I guess what I am needing is the SQL for the computer report but I want to run this on all PC's and export a report.