Ytria logo TUTORIALS

This website require JavaScript for full functionality. Please enable JavaScript in your Web browser.



How can I find out when databases were accessed last?


By using databaseEZ's built-in User Activity Analyzer tool, you can retrieve a full report of who accessed which databases, and when.

Before you begin:

Because only those databases that have user activity recorded can have their user activity analyzed, verify the recorded user activity settings on your databases.
  1. With your databases loaded in the Main grid panel and the full database information loaded, make sure that the column 'User Activity – Is Recorded' is visible in the grid; if it isn't, show the column via the Grid Manager.
  2. Group your grid entries by this column.
  3. Only databases that display as Checked (User Activity is Recorded) will have the recorded user activity information necessary to use the User Activity Analyzer.
Image of databaseEZ's main panel showing which databases have user activity recording enabled.

Using the User Activity Analyzer

Image of databaseEZ's main grid with the User Activity Analyer option selected.Step 1 Select the desired databases to analyze.
Step 2 Select the 'Tools > User Activity > User Activity Analyzer…' menu option.
Image of databaseEZ's User Activity Analyzer option dialog.Step 3 Set the Date-Time Range Filter. For this example, 'Include everything' is set.
Step 4 Click 'OK'
Image of databaseEZ's User Activity panel showing the results of the analysis.Step 5 Go to the 'User Activity' panel by clicking on its tab. If this is not visible, activate it in the 'Panels' top menu.
Step 6 Group the 'User Activity' grid data by the column 'Database Title'.
Step 7 Sort the grid by the column 'Date/Time', and then perform another grouping using this same column.

You will now see a breakdown of all analyzed databases as well as the dates and times they were accessed. You will also find information about the user who accessed the database within each Date/Time entry.