Table Usage Analysis
The Table Usage Analysis app provides insights into which users are accessing specific tables in the database. It helps track both read and write operations on tables, making it easy to identify the users interacting with a table and their respective access patterns.
Installing and opening the Table Usage Analysis app
Refer to Installing and opening apps in Unravel.
Analysing Table Usage
Under Input Options, select the required Data Range and Queue and click Submit. The table usage data is displayed in the form of a table.
The following fields are displayed in the Table Usage Analysis table:
Field | Description |
|---|---|
Database Name | The name of the database containing the table being accessed. |
Table Name | The name of the table that is being accessed. |
List of Users Reading | A list of users performing read operations on the table. |
List of Users Writing | A list of users performing write operations on the table. |
Path | The path through which the user is accessing the table |
Last Accessed Time | The timestamp when a user last accessed the table, either for reading or writing. |
