Custom query

Custom query

Hi,

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
server1.customer1.local
Azure AD Connect
2.0.91.0
Customer 2
Server 1
server1.customer2.local
Azure AD Connect
2.0.28.0

Thanks in advance!
Best regards,
Conny

                  New to ADSelfService Plus?