Stop all database services on named instance in a host with 2 Sql Server installation

[acap (Alen Cappelletti)]

Hi all,
I’m on a HOST (my local notebook) for my tests…
and in this I got 2 instances of SQL SERVER:

• default
• named (ALEN)

It’s not clear to me how remove all service (SQL SERVER) that now are also on ALEN (like the backup in the picture).

I manage to block them but only 1 at a time… and since there are so many DBs it’s a bit boring. Isn’t there a quick way to filter with a rule? Sorry for the banality but I’m still with the first tests and the interface isn’t very simple for my level.

Thank you all

[bkuhn (Bastian Kuhn)]

You can use the “Disabled Services” Rule to just add the Service Names (Regex, startswith match outof the box) which you want to ignore. You can do that Globlay, if you add no other Condition or limit that to the folder where you place the rule, to hosts with labels or tags, or directly to hosts.

[acap (Alen Cappelletti)]

Thanks for your reply… its very powerful! Amazing!
but what I wrote… is a regexp side checkMK?

one more…

I found here a way to exclude a named instance in my host using .ini settings …

• Exclude MSSQL instances from monitoring
  is it enough that I insert the name like the example I report?

[auth]
type = db
username = sqlmonitor
password = baubau
[instance]
exclude = HP-PROBOOK\ALEN

Thanks ALEN

[acap (Alen Cappelletti)]

I updated my regexp…
LIKE: MSSQL[_ a-z].*ALEN

Now I catch everything on the named instance… seems not work with the exclusion into .INI…
but I need some time to try.

BUT…
How can I be sure of all services blocked by my regexp? There is no way to see the list… in reverse, so as to be sure of everything excluded. M ain this case is the display blocked or also on the SQL side the call for that instance?

ALEN

[acap (Alen Cappelletti)]

Found here… under property of the host…