Audit Reports

The following sample SQL queries can be used to generate reports based on Administrative Audit and Login Audit data.

• Sample Administrative Audit SQL query:

  SELECT ActionID, ActionKey, StatsAuditKey.AuditText, ActionDateTime, ModuleName, ModuleUniqueID, UserID, UserName, StationID, SiteName, Param1, Param2, Param3 FROM StatsAdministrative JOIN StatsAuditKey ON StatsAdministrative.ActionKey = StatsAuditKey.AuditKeyID WHERE ActionKey > 100

• Sample Login Audit SQL query:

  SELECT ActionID, ActionKey, StatsAuditKey.AuditText, ActionDateTime, ModuleName, ModuleUniqueID, UserID, UserName, StationID, SiteName 
  FROM StatsAdministrative JOIN StatsAuditKey ON StatsAdministrative.ActionKey = StatsAuditKey.AuditKeyID WHERE ActionKey < 100