public interface AuditQueryService
Modifier and Type | Method and Description |
---|---|
String |
executeAuditEntryDetailQuery(AuditEntryDetailQuery query,
ExtractFileCreateInfo file)
Extracts audit entries with details to a file based on the specified query.
|
String |
executeAuditEntryQuery(AuditEntryQuery query,
ExtractFileCreateInfo file)
Extracts audit entries to a file based on the specified query.
|
String executeAuditEntryQuery(AuditEntryQuery query, ExtractFileCreateInfo file) throws QueryException
QueryLimitException
will be thrown.
Here is a simple example that queries audit entries, which includes all available columns, for a specific user sorted by date.
AuditEntryQuery query = new AuditEntryQuery(); query.select(AuditEntryQuery.ALL); query.constrain(Comparison.equal(AUDIT_ENTRY_USERID, "userxyz")); query.order(Order.descending(AUDIT_ENTRY_TIMESTAMP)); service.executeAuditEntryQuery(query, fileInfo);
Here is an example of a more complex query of audit entries for logins, successful or unsuccessful, within the last month, sorted first by userid and then by date.
AuditEntryQuery query = new AuditEntryQuery(); query.select(AUDIT_ENTRY_USERID, AUDIT_ENTRY_ACTION, AUDIT_ENTRY_TIMESTAMP); Date oneMonthAgo = DateUtils.addMonths(new Date(), -1); query.constrain( Condition.and( Condition.or( Comparison.equal(AUDIT_ENTRY_ACTION, AuditConstants.ACTION_SESSION_LOGON_SUCCESSFUL), Comparison.equal(AUDIT_ENTRY_ACTION, AuditConstants.ACTION_SESSION_LOGON_FAILED)), Comparison.greaterThan(AUDIT_ENTRY_TIMESTAMP, oneMonthAgo.getTime()))); query.order(Order.descending(AUDIT_ENTRY_USERID), Order.ascending(AUDIT_ENTRY_TIMESTAMP)); service.executeAuditEntryQuery(query, fileInfo);
query
- The audit criteria with which to query.file
- The method to add the query output file.QueryException
- Thrown when there is an issue generating the query.String executeAuditEntryDetailQuery(AuditEntryDetailQuery query, ExtractFileCreateInfo file) throws QueryException
QueryLimitException
will be thrown.
Here is a simple example that queries audit entries with details, which includes all available columns, for a specific user sorted by date.
AuditEntryDetailQuery query = new AuditEntryDetailQuery(); query.select(AuditEntryDetailQuery.ALL); query.constrain(Comparison.equal(AUDIT_ENTRY_USERID, "userxyz")); query.order(Order.descending(AUDIT_ENTRY_TIMESTAMP)); service.executeAuditEntryDetailQuery(query, fileInfo);
query
- The audit criteria with which to query.file
- The method to add the query output file.QueryException
- Thrown when there is an issue generating the query.<i>Copyright (c) 2020, SAS Institute Inc., Cary, NC, USA</i>