nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Alert displayed times for Node.UnManaged = No

Bahlkris

Hello, first and foremost, my sql fu is not strong.

I am writing a message body for a generic volume alert that is packed with all sorts of valuable data. But one paticular paragraph is giving me some grief.

Is the system currently in maintenance mode? - ${Node.UnManaged}
Scheduled downtime from: ${Node.UnManageFrom} to ${Node.UnManageUntil}

Basically if ${Node.UnManaged} returns a "No" then the whole second line returns begining of time values. Basically what I am wondering is there a SQL statement I can use that says if ${Node.UnManaged}=No then can the second line be ommited entirely, and if ${Node.UnManaged}=Yes then go ahead and insert the second line. Because obviously in a "Yes" scenario the ${Node.UnManageFrom} and ${Node.UnManageUntil} would contain valid data that I want.

But as I said before, my sql fu is not strong. I basically know how to round and I have selected a few captions to get rid of drive labels on volume alerts.

Any help/advice is greatly appreciated.

-b

Find more posts tagged with

unmanagefrom

unmanageuntil

Accepted answers

bniksich

Try this out. I have got it working. This also uses a quick html to pop out the time on the email

<font color="#0000FE" size="+1">
${SQL:SELECT CASE UnManaged WHEN '1' THEN 'Scheduled downtime from: ' + CONVERT(VARCHAR,UnManageFrom,100) + ' to ' + CONVERT(VARCHAR,UnManageUntil,100) END FROM Nodes WHERE NodeID = '${NodeID}' }
</font>

All comments

qle

There might be a way for ${Node.UnManageFrom} and ${Node.UnManageUntil} to appear blank when ${Node.UnManaged} is No. However, I'm not aware of any method to remove the entire second line based on ${Node.UnManaged}'s value.

bniksich

Try this out. I have got it working. This also uses a quick html to pop out the time on the email

Bahlkris

Works perfectly, thanks.

-b