I'm not sure I understand exactly what you're asking but I think you're wanting
to create a report that shows Computer Name, User ID and limited to a specific
collection, but where you can prompt for a collection. Is that right? I'm not
very good at writing SRS reports so I can't help you with the prompt but this
query below can be run in SQL studio to essentially do the same thing, just
substitute the collection ID.
SELECT DISTINCT
sys.Name0 'Asset Tag',
sys.User_Name0 'User ID'
FROM v_R_System sys
LEFT OUTER JOIN v_R_User USR ON USR.User_Name0 = SUBSTRING(sys.User_Name0,
CHARINDEX('\', sys.User_Name0) + 1, LEN(sys.User_Name0))
WHERE USR.Unique_User_Name0 in (select SMSID from
_RES_COLL_<COLLECTIONID>)
ORDER BY sys.Name0
From: [email protected] [mailto:[email protected]] On
Behalf Of Poole, Richard
Sent: Wednesday, October 08, 2014 1:56 PM
To: [email protected]
Subject: [mssms] All computers for a user collection
Hello everyone,
So I've tried using many of my current reports, that use collection membership
to display properties for a group of systems, with user collections to no
avail. To make it simple, just a query that displays the system name and user
name, with v_R_System joined to v_FullCollectionMembership=@CollectionID. What
changes to the query/parameter need to be made to make the collection switch,
or is there one?
Thank you,
Richard
Poole<https://www.mcpvirtualbusinesscard.com/VBCServer/richardpoole/card>
________________________________
Confidentiality Notice: This e-mail is intended only for the addressee named
above. It contains information that is privileged, confidential or otherwise
protected from use and disclosure. If you are not the intended recipient, you
are hereby notified that any review, disclosure, copying, or dissemination of
this transmission, or taking of any action in reliance on its contents, or
other use is strictly prohibited. If you have received this transmission in
error, please reply to the sender listed above immediately and permanently
delete this message from your inbox. Thank you for your cooperation.
