Feature Request: Search and Mass Clear

BrandonGalderisi

I would like the ability to search alerts and then mass clear.

Example of Search Alerts:
All Low priority, long-running query, from host name GREENSQL1.

Example of Mass clear:
Under Select, along with "All", "None", "Read" and "Unread", I would like to see "Select All" which spans across pages.

The mass clear would be used in conjunction to mass clear long running queries from a particular host.

priyasinha

Hi Brandon,

Thanks for your post.

This feature is already present in SQL Monitor. You can follow the following steps:

1. Select host name "GREENSQL1" on the left hand navigation.
2. Create the filter for "Long running query" + Low priority using Advanced Filter option.
3. Now use Select > All option.
4. You would notice that a green bar appears at this stage with hyperline for "Select all alerts across all pages".
5. Use this option to select all alerts across all page and then perform any action such as "Read", "Cleared" etc.

Thanks,
Priya

BrandonGalderisi

By host, I mean host connecting to the SQL Server, not the server itself.

priyasinha

Hi Brandon,

Apologies, but not sure I understand what you are refering to? Could you explain it bit more please?

Thanks,
Priya

BrandonGalderisi

I know that I have a particular process that runs on a particular machine that trips the long running query alert. I would like to do a search of "all connections from the host name of......". If you look at an alert, it's the HOST value.

priyasinha

Hi Brandon,

Thanks for explaining. For your reference, I am tracking it as SRP-3615.

Thanks,
Priya