sfbpf42

Thank you mate. This was not precisely what we were looking for, but it will work as a charm Thank you so much for sharing knowledge and wisdom

Good morning It looks that this did the trick. Thanks a bunch Minor additional question:The query returns a response in one quarter of time than it does in Management Studio. Any ideas why this happens

Not good, it optimizes the query and it returns the result very quickly

Hello to all Thanks everybody for all the answers. As njoylif suggested, I opened a case with Solarwinds. They proposed the field ${N=SwisEntity;M=ComponentAlert.Description} and, in addition, to set the alert to "Component"and not to "Application". It didn't return anything, but when I changed it to "Component", the field…

Well, this neither is working the variable ${N=SwisEntity;M=ComponentAlert.UserNotes} is appearing as is in the email

It's SAM 6.2.4 (Orion 2016.1.5300)

Dear njoylif Thanks for the reply and support Unforunately,none of your suggestions worked The variables seem they are not valid, they are showed as they are in the e-mail

Well, that's true. Thanks for the reply. The only problem is (and I'm saying this just to let people know) that the old notifications are lost. The bar is back, but the old notifications not Thanks again

Hello and thanks for the reply This is exactly what I have done until now, and I get error "Unable to convert query result", probably because the query returns a lot of rows and not a simple number Is there a way to bypass it? I am not interested in the results, but only in the time that it took to execute Thanks in advance

Hello again Sorry for the delay of my answer. Well, with the cmdlets my work is very hard. A colleague of mine found AD Tiny, which gives me the data very easily Thank for the support and help