Query request
I need to run a query for the following:
For all workstations in the ABC domain, show the total installation count for all software apps on all workstations.
In other words, let's say I have one workstation with Program1, Program2, and Program3, another workstation with just Program1, and yet another workstation with Program1, Program2, Program3, Program4, and Program5, all in the ABC domain, and I also have workstations in the XYZ domain that have some of the same programs. I would like to get a list of each software title found on any computer in the ABC domain and how many of those workstations it's installed in, like this:
Program1 - 3
Program2 - 2
Program3 - 2
Program4 - 1
Program5 - 1
All the software is currently at Unidentified status. Is this possible?
For all workstations in the ABC domain, show the total installation count for all software apps on all workstations.
In other words, let's say I have one workstation with Program1, Program2, and Program3, another workstation with just Program1, and yet another workstation with Program1, Program2, Program3, Program4, and Program5, all in the ABC domain, and I also have workstations in the XYZ domain that have some of the same programs. I would like to get a list of each software title found on any computer in the ABC domain and how many of those workstations it's installed in, like this:
Program1 - 3
Program2 - 2
Program3 - 2
Program4 - 1
Program5 - 1
All the software is currently at Unidentified status. Is this possible?