Hello Can someone please help to modify this report query to show only date/time from January 1, 2014 onwards?
SELECT st.RecordID, Time, (select InsStrValue From v_StatMsgInsStrings as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=0) as 'Remote Controlled By', (select InsStrValue From v_StatMsgInsStrings as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=1) as 'Remote Controlled From' , (select InsStrValue From v_StatMsgInsStrings as Ins where Ins.RecordID=st.RecordID and Ins.InsStrIndex=2) as 'Computer being Remote Controlled', sys.User_Name0, st.sitecode FROM v_StatusMessage st join v_R_System SYS on SYS.Name0 = St.MachineName WHERE st.MessageID = 30076 AND Component='Remote Control Viewer' AND st.sitecode = US0 Order by st.Time DESC
