Hi

i want SQL Query that result as below picture

thanks

I assume that you have tried to create the report yourself and I having problems, What do you have so far?

So Seyed, Again I will ask What does you query look like and what problems are you having with the query that you have created?

Sorry I can't read your mind.

What's under the resources?

Do you have a query already?

here you go with SSRS Report created for CM12 but you can modify it http://eskonr.com/2013/10/sccm-configmgr-ssrs-reportlist-all-collections-with-count-of-client-installedassignedactive-and-obsolete/