This content has been marked as final. Show 2 replies
Is there a way to query the resources/queries used by a specific SQL Server login? I believe the data is available in the Ignite/DPA repository, as there is a DPA tab called "DB Users" which shows queries by day and SQL login.
I found this query, SS TopSQLforOSUser SQL , but the query does not appear to do what I expected or my Ignite repository data structure is different than the query.
Any suggestions, ideas or does anyone have a query they can share?