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]>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" > >
