Need help creating custom report to show installed software on devices on certain domain

I basically need to create a report to show a list of all the software and on how many devices on a certain domain. 

I can get a report to show all the software and how many devices have it but struggling to show all the software on devices that are on the specific domain.

I don't need to show any devices details or domain details.

Just need software name, software version and how many devices it is installed on.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 years ago
Red Belt

So join your MACHINE table to the USER table using MACHINE.USER = USER.USERNAME and that will allow you to select the USER.DOMAIN value for the machine.

You should then be able to build your report with USER.DOMAIN in your WHERE statement, maybe even break the report on that column to split the report by domains?

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ