Querys to go..

[Weiry]

Hi

 

I was wondering if anyone knows of a good resource to learn about "queries" I would like to know the basics and get a better knowledge and understanding of how to put them together. There seems to be a lot of choices in the drop down lists and I'm looking at finding more about these.

 

I know there are a lot of pages out there that show you certain scenarios but I would quite like to get a good grasp myself.

 

Thanks for your help

 

[GarthMJ]

Queries for what AD?

[Weiry]

Hi Garth

 

I was thinking more about collecting machines for groups, returning specific results based on PC resources. Showing the last time they logged in, things like that really.

Things to make an Admins job easier.

 

I guess we could even use this post for others to post their favorite SCCM and other WQL queries.

 

Cheers

[GarthMJ]

So I should move this post to CM12 forum or the Reporting forum?

 

BTW you will find a ton of queries on www.smsug.ca ;-)

[Weiry]

Thanks very much, that's excellent Garth

[GarthMJ]

BTW you can also get the free month report from here. http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx