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