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 Name	FQDN	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!