Best Of
-
Re: Trigger Action - Email SWQL/SQL in body
Sure thing. I always appreciate someone taking their time to look over things. It's my first dive into custom SWQL alerting so took me ages to get this far. Firewall Connections over 90% on ${N=…1 -
Re: Trigger Action - Email SWQL/SQL in body
@"smalleggo" Could you post the full content of the action you are trying to build? Maybe this will help in spotting the issue. For example, in your last two posts you are missing the } at …1 -
Re: Trigger Action - Email SWQL/SQL in body
Sorry, I have attempted both ways as shown below. This same query works without issue on the dashboard or going against the DB itself. The issue is specifically the email body which has other variabl…1 -
Re: Trigger Action - Email SWQL/SQL in body
Hi, as @"maciej.sandecki" said, you are stating that it's a SQL query when it's actually a SWQL query. Here is a simple one: ${N=SWQL;M=SELECT N.caption from Orion.Nodes as N WHER…1 -
Re: Trigger Action - Email SWQL/SQL in body
I'm not a DBA, but we have a working SWQL query in an email from a UPS Alert. I'm not sure it will help, but I'll put the code we use here for your review. Nothing special in the alert…1 -
Re: Trigger Action - Email SWQL/SQL in body
I've made it super simple in the attempt to get it to display. Doing the SELECT into a widget displays the single number I am expecting however the email using SQL/SWQL and <p> </p> …1 -
Trigger Action - Email SWQL/SQL in body
I have SWQL code that creates a table from two UnDP with an output of a percentage. The RawStatusRatio and the the SecondAssignment is what I need in an email for alerting purposes. The original SWQ…1 -
Re: SQL SPN issue - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
thanks for the info, but our servers is not joining any domain for the IIS part which identity should I used? curretly is ApplicationPoolIdentity for the service it's running under Local System …1 -
Re: SQL SPN issue - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Disclaimer: The content posted herein are provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third party website or customers. Sol…1 -
Re: SQL SPN issue - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
thanks @"maciej.sandecki" issue is fixed after switching to SQL auth on MPE and APEs last seen log on 23rd Jun, until now no log generated again this also improve overall performance such a…1
