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.
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?