Logging Facility

As commands are processed, they are logged on a separate worksheet in the active workbook. This sheet has the name "$Log" and is created and maintained automatically as commands are processed. There are several purposes and uses for the logging facility:

• Maintain a record of the commands entered for reference and possible inclusion in the work-papers
• Provide the capability to re-process commands by copying and pasting the command text into the toolbar
• Provide the basis for storing the commands processed permanently into the Windows registry through the use of the "sc" (save command)
• Provide a starting point for future reviews, should similar type processing be performed

An example of a log sheet

Saving the contents of a log sheet permanently.

The contents of the log sheet can (optionally) be edited in Excel and then saved to the registry using the save command. Assuming that the log sheet is named "$Log" and it is desired to store all the commands on the sheet into the registry as a group named "Audit1011", the save command would be as follows:

sc sheet=$Log col=Command name=Audit1011