Jump to content


brink668

Find what Collections a computer is apart of?

Recommended Posts

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? 

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.