Find what Collections a computer is apart of?

[JFX]

On 4/26/2013 at 3:21 PM, GarthMJ said:

You can run a query to get this info.

 

select 
	C.CollectionID,
	C.Name,
	C.Comment
from 
	dbo.v_Collection C
	join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID
Where
	FCM.Name = 'ES-06'

 

Do you happen to know how to make this work as a "query" in console so that it prompts the computer name when run? 

[GarthMJ]

First off this is not easy to do in the console.

Secondly why would you do it in the console?

[dsmonroe63]

On 5/8/2016 at 0:29 PM, GarthMJ said:

If you are looking to get better writing reports, first I will tell you to stop using Report Builder and use SQL Server Data tools (SSDT) or Business Intelligence Development Studio (BIDS) instead.

 

If you will be at MMS next week there are several presentation on writing reports.

 

Lastly, if you are looking for a book on the subject then I would look at this one. :-)

http://www.amazon.com/gp/offer-listing/0672337789

What would you know about repor---

*sees it's Garth Jones replying, fangirling begins*

THANKS!

[GarthMJ]

I'm always around to answer questions but I'm a bit busy with MS Ignite stuff...  If you are at Ignite, feel free to stop by the booth 1246 or if you are going to IT/Dev in Oct, say stop me and say Hi.