Query to find specific software on all computers grouped by "Site"

Query to find specific software on all computers grouped by "Site"

I am in need of a PostgreSQL query that will let me find all of the computers with a specific software (i.e. Office 2016) and grouped by "Site". the query needs to include workstation name, department, site and software name. has one been created or can we get one made please.


                  New to ADSelfService Plus?