What is a one sentence summary of your feature request?
Change the Application Name value in the SSRS connection string to be unique and easily identifiable.
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
When troubleshooting back-end database issues/evaluating resource consumption, it is hard to tell what activity is generated by the Auditor UI vs the Auditor services vs SSRS report execution. In the Data Source that gets created for SSRS (DS_Common) the Application Name in the connection string is “Netwrix Auditor”, but this can be confusing.
I recommend something unique like “SSRS - Netwrix Auditor” so we can tell what queries are being executed by SSRS vs the other components.
*** I would go further and have each service that connects to SQL Server do so under its own unique Application Name. This is critical when troubleshooting issues and evaluating resource consumption.
How do you currently solve the challenges you have by not having this feature?
There really isn’t a way. It is a lot of guessing and trying to match execution times to resource metrics snapshots.
