Creating a custom Access Query

Top  Previous  Next

If you have Microsoft Access installed then you can simply open the EventSentry access database (EventSentry.mdb) and look at the Event Log query to see a history of all backup activity.

 

If you are logging more than just the NTBackup events to the database then you can also copy the Event Log query to create a new query that will only show NTBackup events. Open the EventSentry access database and click the Queries button:

 

es_logging_access_1

Figure 20

 

Select the Event Log query and click the copy button and then the paste button on the toolbar. Enter a descriptive name (e.g. Backup History) when prompted for a name of the new query.

 

To change the query select it and click the Design button on the toolbar. In the design editor, specify NTBackup for the criteria and click the save button as shown below:

 

es_logging_access_2

Figure 21

 

and the resulting query will only show events from the NTBackup source.