Custom query

Custom query


I need assistance with building a custom query in EC MSP that queries all assets across all customers for a specific software without having to do specific reports on every single customer.

What is need to pull is Customer Name, Name of the server/workstation, FQDN, Name of the installed software, Version of the installed software,

I.e. in this particular case I'm looking for installed versions of Azure AD Connect so I'd like to see a result similar to the following:

Customer Name
Asset NameFQDN
Software Name
Software Version
Customer 1
Server 1
Azure AD Connect
Customer 2
Server 1
Azure AD Connect

Thanks in advance!
Best regards,

                  New to ADSelfService Plus?