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"
