How can I use DPA to report on top SQLs and Exclude those marked to exclude from Trend charts?

Question

My executive team would like to see trending reports from DPA without the clutter of the SQLs that have been marked to not include in the Trend Charts.  Can someone point me in the right direction to create a report with this data?

Thanks,

Remo Mills

DPA 10.0.352 on MS SQL

remo.mills · Answer

Thanks for the idea.  I'll have to give that a try.

m60freeman · Answer

I created  as a Feature Request. remo.mills‌, please vote for it.

mandevil · Answer

Currently the reports are rendered by a separate engine than the trend view.

At this point, you are going to need to do a manual workaround.

Let DPA choose the top 15 sql hashes and copy off the hash values in the report.

Once you have the top 15, you can then edit the report definition to be user defined and paste back in any sql hash value you want (so remove the excluded one from trends).

I think it's a great idea though to have the option to honor the excluded from the trend view.  Feature request?