Hello Elias Thank you. I'll try this:)
Criselda Hilvano GDE Team From: [email protected] [mailto:[email protected]] On Behalf Of Elias Leal Sent: Friday, April 11, 2014 2:24 PM To: [email protected] Subject: Re: [mssms] customizing sccm report query for Remote Control - Al l remote control information Criselda, I don't use the Remote Control feature so I can't verify this in my environment, but perhaps this may work... ="SELECT st.RecordID, Time, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=0) as C056, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=1) as C057, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=2) as C058 FROM fn_rbac_StatusMessage(@UserSIDs) st join v_FullCollectionMembership FCM on st.MachineName=FCM.Name WHERE st.MessageID = 30076 AND Component='Remote Control Viewer' AND FCM.CollectionID='<INSERT YOUR COLLECTION ID HERE>' Order by st.Time DESC" The original view is using the v_StatusMessage view. The only useful column I could see was 'machinename' to form a join relationship with the 'name' column in the v_FullCollectionMembership view. If this works, you may want to replace the 'v_' with 'fn_rbac_' and insert the (@UserSIDs) accordingly if you want to maintain the proper role-based permission for reporting. Elias On Thu, Apr 10, 2014 at 11:50 PM, Hilvano, Criselda <[email protected]<mailto:[email protected]>> wrote: Hello Can someone please help to modify this query ( Remote Control - All remote control information) to add a specific collection id? Is this possible with this expression? ="SELECT st.RecordID, Time, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=0) as C056, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=1) as C057, (select InsStrValue From fn_rbac_StatMsgInsStrings(@UserSIDs) as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=2) as C058 FROM fn_rbac_StatusMessage(@UserSIDs) st WHERE st.MessageID = 30076 AND Component='Remote Control Viewer' Order by st.Time DESC"
