The Audit Log Report allows you to generate a list of audited events in your RecTrac database. The report may be filtered by common/standard criteria, such as Date Range, Usernames, and Source Programs. Additional Detail filters allow you to narrow the output to more specific events, if needed.
Click Here to See a Sample Report.
The Audit Log Report can be output to .pdf or .csv file types. However, unless you have a specific reason for needing a .pdf or a spreadsheet(.csv), then VSI strongly recommends using the Audit Log Inquiry program for queries against your Audit Log. The Audit Log Inquiry is easier and faster to run, and it provides more detailed data. Likewise, if your intent behind running the Audit Log Report is to determine "who did what and when was it done," then VSI recommends using the Audit Log Inquiry program for the reasons stated above.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Core Criteria
Use Date Range (SAAuditLog_LogDate_UseRange)
Select this option to filter the report output by Date Range (the date on which the event was audited, if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending Date range.
OR
Leave this option de-selected to skip the Date Range check.
Program Exclude List (SAAuditLog_ProgramExcludeList_Equals)
Enter any programs you want EXCLUDED from your report output. Generally you will use this feature when running the Audit Log for all programs (i.e. the Source Program field is left blank).
If excluding more than one program, delimit your list with commas and omit all spaces. For Example: login,maintenance.
Leave this field blank if you do not want to exclude any programs.
DeleteBegin Transaction Date (SAAuditLog_LogDate_Begin)
This field is applicable only if you opt to Use Date Range.
Expand the Drop-down list and select your Begin/End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Events for which Audit Log records were made in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Transaction Date (SAAuditLog_LogDate_End)
This field is applicable only if you opt to Use Date Range.
Expand the Drop-down list and select your Begin/End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Events for which Audit Log records were made in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUsername (SAAuditLog_UserName_Equals)
Click the Combo Box icon to select the Username(s) by which you wish to filter the report output, if any.
THEN
Take appropriate action in the Username Options field. For best results, use the Equals" option if looking for audited events by a specific user or users. For Example: You are looking for audited events performed by users Sergeantp and Lorettam. You would enter "Sergeantp Lorettam" in the Username field and select "Equals" in the Username Options field. The report would yield audited events by those two users only.
Leave this field blank to skip the Username check and run the audit log for all users.
DeleteUsername Options (SAAuditLog_UserName_Equals_Option)
This field is applicable only if you opt to filter the report by a specific user or users.
Expand the Drop-down list and select your Username Options for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
For best results use the "Equals" option if looking for audited events by a specific user or users. For Example: You are looking for audited events performed by users Sergeantp and Lorettam. You would enter "Sergeantp Lorettam" in the Username field and select "Equals" in the Username Options field. The report would yield audited events by those two users only.
DeleteSource Program (SAAuditLog_SourceProgram_Equals)
Enter all or part of the Source Program by which you wish to filter the report
THEN
Take appropriate action in the Source Program Options field. This field does NOT allow multiple entry, nor does it allow for Wildcarding.
Examples:
- Entering Maintenance" and setting the Options field to "Equals" would filter the report output to File Maintenance audit records only.
- Entering "B" and setting the Options field to "Begins" would filter the report by all programs that begin with "B such as but not limited to: BeautifyFields, BulkChange, BulkUnsoldTicketPrint, etc….
Leave this field blank to skip the Source Program check and run the audit log for all programs, save for those in the Program Exclude List, if any.
DeleteSource Program Options (SAAuditLog_SourceProgram_Equals_Option)
This field is applicable only if you opt to filter the report by Source Program
Expand the Drop-down list and select your Source Program Options for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Examples:
- Entering "Maintenance" as the Source Program and setting the this field to "Equals" would filter the report output to File Maintenance audit records only.
- Entering "B" as the Source Program and setting this field to "Begins" would filter the report by all programs that begin with "B such as but not limited to: BeautifyFields, BulkChange, BulkUnsoldTicketPrint, etc….
Detail 1 (SAAuditLog_Detail1_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 1 Options (SAAuditLog_Detail1_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 2 (SAAuditLog_Detail2_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 2 Options (SAAuditLog_Detail2_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 3 (SAAuditLog_Detail3_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 3 Options (SAAuditLog_Detail3_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 4 (SAAuditLog_Detail4_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 4 Options (SAAuditLog_Detail4_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 5 (SAAuditLog_Detail5_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 5 Options (SAAuditLog_Detail5_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 6 (SAAuditLog_Detail6_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 6 Options (SAAuditLog_Detail6_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 7 (SAAuditLog_Detail7_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 7 Options (SAAuditLog_Detail7_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 8 (SAAuditLog_Detail8_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 8 Options (SAAuditLog_Detail8_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.
Detail 9 (SAAuditLog_Detail9_Equals)
Enter all or part of the Detail by which you wish to filter the report
THEN
Take appropriate action in the corresponding Detail Options field. Detail fields do NOT allow multiple entry, nor do they allow for Wildcarding.
Leave this field blank to skip the Detail <x> check and run the audit log for all Detail Options that meet your other selection criteria.
Detail records are created by the system as part of the audit logging process, so when entering data in these fields, it is best to have some idea of the details you're seeking. It is unlikely that your report will yield expected results if you enter random numbers or characters in these fields.
Examples:
- Entering Maintenance" as your Source Program entering "SAHousehold" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the SAHousehold table that have a Record ID starting with the number "2." To find the actual household(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SAHousehold ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
- Entering "Maintenance" as your Source Program entering "ars" as your Detail 1 option and setting the Detail 1 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table which would include ARSection Add Update and Delete.
- Using the same settings as above but also entering "2" as your Detail 2 option and setting the Detail 2 Option field to "Begins" would filter the report output to File Maintenance audit records linked to the ARSection table that have a Record ID starting with the number "2." To find the actual ARsection(s) linked to the Record ID you would use the DB Inquiry program. Table to View = SASection ID="xxxxxx where xxxxxx" is the Record ID you wish to view.
Notes:
- You can skip fields if desired such as skipping the Detail 1 field and entering data in the Detail 2 field. For Example: Entering "Maintenance" as your Source Program skipping the Detail 1 field then entering "2" as your Detail 2 option and setting the Detail 1 Option field to "Begins" would filter the report output to all File Maintenance audit records that have a Record ID starting with the number "2." These could be Household records Family Member Records Activity Records Pass Records etc….
- Use the Audit Log Inquiry program to quickly and easily find the Detail Options linked to audited events. Unless there is a valid reason for needing a .pdf or spreadsheet output of the Audit Log VSI recommends always using the Audit Log Inquiry program to review audited events in RecTrac.
Detail 9 Options (SAAuditLog_Detail9_Equals_Option)
This field is applicable only if you opt to filter the report by Detail <x> where "x" is the Detail field that corresponds to this one.
Expand the Drop-down list and select your Detail <x> Option for this report:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match.
- Begins - The process will return a list all records that begin with the value entered.
- Ends - The process will return a list all records that end with the value entered.
- Matches - The process will return a list all records where a value match can be found.