Example: Identifying Users Recently Forced Off the System - Advanced SQL Engine - Teradata Database

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 ;