Quick User Guide for Audit Master

Release Date: 09/12/2018

If you need help with installing Audit Master, please reference the following KB article:

Use Audit Master Viewer
From your desktop, find "Audit Master Viewer" to startup.  Expand your server node, enter “Admin” and password. If you don't know the password, ask your admin.  If you are the admin, call Netcellent.  

One of the quirky things with Audit Master is that you cannot immediately view the real time auditing data.  Instead, you need to first right click “Current View File” and choose “Update Current View File” in the drop down menu. A triangle warning sign icon will show up indicating that it is updating the Current View File.  But the icon will never go away until you right click “Current View File” and choose “Update Status.” 

Now right click and choose “Query…”.  You will see the following window show up:

Since Audit Master accumulates a lot of data, usually you need to narrow down the data you want to look for by specifying in the following tabs:
  • Who: Indicates the auditing data from which you specify users' data you'd like to see.  Default is "All" users.
  • Did What: Since Elliott uses the Btrieve engine only, you may narrow it down by using "Insert," "Delete," "Modifying Before" and "Modifying After."  This is under "Operations," Pervasive SQL (BTRIEVE). In addition, under the "Tables" area, you may expand the "Elliott Business Software V8.2" node and select the changes to the specify the table you are interested in seeing.
  • From Where: If you are interested in seeing the changes from a specific workstation and you know the IP address, you can use this tab.
  • When: If you know the changes are taking place on a certain date and time period, you can narrow it down from this tab.
Finally, after you specify the filters in each tab, click on “Execute.” See sample screen on the result below:

Highlight the particular entries on the top that you are interested in seeing.  In this example, it shows the date and the time that the user made a change to a customer record (ARCUSFIL) by dropping the value "USA" from CUS_COUNTRY field (Modify Before vs. Modify After).

In many cases, the data you would like to see may not appear in the current view, in which case you will have to go to the archive.  By default, the archive data is in a compressed mode to save disk space. To access archive data, you will need to first right click on the archive file, and choose "Decompress." See sample screen below:

Then you will see the triangle warning icon show up to indicate that it is in the process of decompressing the file and asking you to wait.  Unfortunately, this warning icon will never go away until you right click on that same archive file and choose "Update Status" in the drop down menu. See sample screen below:

Now you can right click on the uncompressed archive file and choose "Query..." in the drop down menu.

Use Audit Master Viewer Advanced Search
If you are specifically interested in what happens to a particular record. (i.e., you would like to know who made the changes that dropped the "USA" from the CUS_COUNTRY field with customer number 001500), then you should use "Advanced Search."

To use "Advanced Search," right click on the file and choose “Query…” in the drop down menu. Go to the “Advanced” tab. Check “Use Advanced Expression Builder.” See sample screen below:

Click on the “<Select Type>” drop down and choose “Data Fields.”  In the popup window, expand “Elliott Business Software (8.2)” and further expand “<User Tables>.” There, you'll find the “ARCUSFIL” table and expand it. Then scroll down to the very end of this table and choose the “CUS_NO” column, and enter “001500” in the “=” field. Click OK to save. See sample screen below:

Now click "Execute" and see the result.  If there are no records found, then you need to try other archive files.  Since it can be tedious to look at various archive files, we suggest that the maximum audit data file size be 1,024 MB and the maximum number of archive files be set up as 10 in our Audit Master Installation and Setup KB article.  If you can't find the change in the current view, or in all 10 archive files, then it means the change was before the earliest archive file we have.

Additional Technique
The Advanced Search allows you to focus on who and when the change took place. But often when you ask the user why he did what he did, he will tell you, "I don't know."  To shed more light on the situation, one common technique is to use the "Who"  and "When" tabs to see all related activities of what the user was doing at the time.  By seeing the activities of the user, you will have a better sense of what the user did to cause the particular change.  Sometimes, this can be a user procedure issue, in which case you might want to revise your operation procedure to prevent it from happening in the future.  Sometimes, this is an Elliott bug.  As long as you can identify the steps it takes to replicate the problem so that we can replicate the same in-house, we can address the issue for you quickly.  This is why the Audit Master is an invaluable tool.


Pervasive PSQL

  1. Btrieve Error Codes 001 - 199
  2. Btrieve Error Codes 3000 - 3099
  3. Btrieve Error Codes 3100 - 3199
  4. PSQL Version Required by Each Elliott Version
  5. Do I Need to Change PSQL Server Engine Default Parameters After Installing It?
  6. New Elliott PSQL Server Processor and RAM Suggestions
  7. Can I Dynamically Adjust Elliott / PSQL 11 Server Memory?
  8. Received "Your Computer Does Not Have PSQL 10 or 11 Client " Even though PSQL Client Is Just Installed
  9. Btrieve Error 161 on Password File When Starting Up Elliott
  10. Problems with Using Pervasive Rebuild Utility on APOPNFIL and AROPNFIL Tables
  11. Security Issue with Installing PSQL Client Remotely on User's Workstation
  12. PSQL and Distributed File System (DFS)
  13. How Do I Turn on PSQL Relational Engine Security?
  14. An Example of Debugging NOTE_ORD_VIEW PSQL Expression Evaluation Error
  15. Btrieve Error 025 on COP Open Order by Salesman Report
  16. What Is the *.^01 File for My PSQL Btrieve Table?
  17. Suggested Files to be Monitored by Audit Master
  18. Pervasive Backup Agent Is Not Compatible with Creating Work Files
  19. Hardware Recommendations for Your PSQL Database Server
  20. How to Optimize SQL SELECT Statement When Retrieving Data from Invoice History
  21. New User-Defined Functions in Elliott DDF
  22. How to Improve Query Performance When Retrieving Data from Notes & Invoice History
  23. How to Retrieve Tracking Number for an Order from Notes
  24. Actian PSQL Not Started Automatically After Server Reboot
  25. Create a New Database in the PCC for Relational Engine Access
  26. Slow PSQL Relational Engine Performance
  27. IPV6 May Cause Problem for PSQL 11 Relational Query
  28. DDF Files in DATA Folder May Confuse PSQL
  29. What to Do When PSQL 11 License Is Disabled
  30. Quick Installation Guide for Audit Master
  31. Quick User Guide for Audit Master
  32. PSQL 13, Micrsoft SQL Integration Service & Pervasive PSQL OLE DB Provider
  33. Your Firewall Needs to Allow Outbound Traffic to the Netherlands for PSQL Licensing Server Purposes
  34. A Case of Btrieve Error 046 on ARCRCLOG A/R Credit Card Log File
  35. A Support Case of Migrating to Different Version of DDF
  36. How to Clear the Message "Unable to Read your Users record (9/068)"
  37. Setup of the PSQL 13 Report Engine
  38. How to Create CPHSTTRX_VIEW with Left Join to CPINVHDR Due to Invoice Database Archive
  39. How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019
  40. Elliott Database Naming Convention
  41. What Does Btrieve Error 080 Mean?

Feedback and Knowledge Base