Use this query to identify users that were forced off the system in the past two days:
SELECT DISTINCT UserName FROM DBC.LogOnOffX WHERE Event = ’Forced Off’ AND LogDate > DATE - 3 ;
Use this query to identify users that were forced off the system in the past two days:
SELECT DISTINCT UserName FROM DBC.LogOnOffX WHERE Event = ’Forced Off’ AND LogDate > DATE - 3 ;