cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

How do I exclude an machine from report?

Jump to solution

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. 😕

0 Kudos
1 Solution
Level 17

@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

View solution in original post

2 Replies
Level 17

@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

View solution in original post

@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.

0 Kudos