Audit Command Language – Views & Data Sets




Hello people. Welcome to another post in the ‘Audit Command Language Tutorial for Beginners’ series. Without any delay let us discuss an important concept that needs to be understood now that we have covered so many aspects of the tool to manipulate the data files, it becomes important to understand how the tool works with the data.

First let us understand specifically, the data files produced while processing an ACL Audit Command Language project. There are two main aspects to study here. The views and data sets. Let us consider the screenshot below:

When we are looking at the data in the GUI tool, it is essentially the view of the actual data and not the actual data. It is simply a visual representation of the data set. That means, that if any fields are added to a view by using the ‘Add Column’ option, any such fields would not actually be created. In the below screenshot we can see the new field ‘Test_Field’ has been created using the the GUI option. This field is not actually getting added to the data.

This feature can be tested by looking into the actual fields by pressing ‘CTRL + i’ keys. The pop screen lists the actual fields in the data set. In such a view any columns, which are added by using the GUI would not be listed. The screenshot below illustrates this feature.

In order to affect an actual change in the data set with regards to adding new columns/fields, Audit Command Language scripts should be preferably used since in most projects, the creation of new fields should be captured in logs to keep track of the changes to the project. Such changes directly affect an update in the .FIL files that get created for each of the data sets in any ACL Audit Command Language project. Please see a demonstration of the feature described above in the video below:

Such small concepts here and there are very critical in understanding how to work around the tool by using unconventional techniques in the tricky scenario, especially when you are short on time and have to meet urgent deadlines. Knowing such intricate details of the tool is always helpful and this applies for any tool that you may happen to work upon.

Please keep practicing and feel free to reach out to us with your valuable feedback and comments. Please go through the website to review ACL script examples and ACL script commands sign up for our newsletter, so that we may keep you posted on the latest activity on our website and Youtube channel.