How do I exclude an machine from report?

[cuppadan]

Ok, I want to create a DPA Report for "Top Machines Ranked by Cumulative Wait Time".

There is an option to Include a machine under "Machines to Display",  then "User-Defined Machines", However I want to exclude one or two machines but report on the rest of them. Is there a way to do this?

Thanks for any help. 😕

[sqlrockstar · Accepted solution]

@cuppadan There does not seem to be a way to exclude machines from the default report page. So, I have two suggestions.

1. You can search for a similar customer report here, and modify the code as necessary.

2. You can build a report from the report page, for just the machines you want to exclude. Capture the SQL that is generated when the report is run. Modify that code to exclude, rather than include those machine names. 

HTH

[cuppadan]

@sqlrockstar 

Thank you for the suggestions. It will be more work than I wanted but at least I have options. Maybe the devs will add that in the near future.