Die folgenden SQL-Beispielabfragen können verwendet werden, um Berichte basierend auf Administrative Audit und Anmelde-Audit-Daten zu generieren.

• Administrative Audit-SQL-Beispielabfrage:

  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

• Anmeldungs-Audit-SQL-Beispielabfrage:

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