JFX Posted May 10, 2017 Report post Posted May 10, 2017 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? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted May 10, 2017 Report post Posted May 10, 2017 First off this is not easy to do in the console. Secondly why would you do it in the console? Quote Share this post Link to post Share on other sites More sharing options...
dsmonroe63 Posted September 11, 2017 Report post Posted September 11, 2017 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! Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 11, 2017 Report post Posted September 11, 2017 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. Quote Share this post Link to post Share on other sites More sharing options...