This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Alert Variable - Remove Domain Suffix from Sysname

The following variable can be used to strip the domain suffix from the Sysname in an Alert:

${SQL: SELECT RTRIM (SUBSTRING(Sysname,1,((Select CASE WHEN (CharIndex('.yourdomain',Sysname)>0) THEN (CharIndex('.yourdomain',Sysname)-1) ELSE (LEN(Sysname)) END))))  FROM Nodes WHERE NodeID = ${NodeID}}

Replace yourdomain with your actual domain suffix.