How can I see who is actively using a given table?

Curtis2
Giga Guru

I need to be able to analyze which users are accessing/using a given table.  I know I can find this information in syslog_transactions; however, that cannot be reported against and any list query with a date range longer than about 7 days just times out, limiting the value of the data provided.

1 REPLY 1

bammar
Kilo Sage
Kilo Sage

Metrics i think is the best answer. So a metric definition that will create a record every time a user updates a record in a table. This is better than updated by in terms of accuracy but it may be taxing and very large so the more i type the more i dont recommend it. Furthermore - The effort you go to to get this data and what you can do with it may not have utility.  Maybe analytics can be used to track this or perhaps see if you can eliminate users by using their last login date as well. Also if users dont go to an area for a long period of time there may be a business case to remove their access and thus have less of a pool of people to worry about. Finally I know that things like KB articles and I beleieve catalog items have a counter on their usage but not sure if it shows who used them. Ill be curious to see other responses too to see if there is another angle to achieve this efficiently.