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

UDP Advanced Alerts for UPS Monitoring

Hi,

I have tried several snippets of code and various measures to generate an alert with the proper information on remaining battery status for APC UPS's.

The code I have tried in SQL Management Studio gives a constant error on

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '{'.

The SQL query is-

Select Status From CustomPollerAssignment as Assignment, CustomPollerStatus as Status where Assignment.CustomPollerAssignmentID = Status.CustomPollerAssignmentID and Assignment.NodeID = ${NodeID} and Assignment.AssignmentName like 'Custom_Poller_Name'}

What am I doing wrong here? BTW I am not a SQL master.

Thanks,

jellis

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet