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

Query

I am having trouble in my second WHERE clause. I don't have the right syntax for the property I want to exclude, but I don't know how to find the correct one.

SELECT * FROM dbo.AlertLog

WHERE LogDateTime BETWEEN Convert(DATETIME, '2/1/2015') AND CONVERT(DATETIME, '2/11/2015')

WHERE ActionType <> "AlertReset"

ORDER BY LogDateTime DESC;

I've tried <>, != and /= and "AlertReset" "Alert Reset" AlertRest 'AlertReset' 'Alert Reset'

Please help,

Lance

Find more posts tagged with

Accepted answers

FormerMember

A better one yet to weed out the "Alert Reset" Emails and just limit it to the Successful Emails.

SELECT * FROM dbo.AlertLog

WHERE

(LogDateTime BETWEEN Convert(DATETIME, '2/1/2015') AND CONVERT(DATETIME, '2/11/2015'))

AND ActionType = 'Email'

AND Message LIKE 'Success%'

AND Message NOT LIKE '%Alert Reset%'

AND Message NOT LIKE '%is Up%'

ORDER BY LogDateTime DESC;

All comments

FormerMember

With some help from my boss and realizing I had the objects mixed up I figured it out on my own.
For anyone interested in this query.

SELECT * FROM dbo.AlertLog

WHERE (LogDateTime BETWEEN Convert(DATETIME, '2/1/2015') AND CONVERT(DATETIME, '2/11/2015')) AND Message <> ('Alert Reset')AND ActionType = ('EMail') AND Message Like ('%Success%')

ORDER BY LogDateTime DESC;

Or whatever dates you want to see the alerts from, shows all of the successful emails and excludes "Alert Reset"

FormerMember

A better one yet to weed out the "Alert Reset" Emails and just limit it to the Successful Emails.

SELECT * FROM dbo.AlertLog

WHERE

(LogDateTime BETWEEN Convert(DATETIME, '2/1/2015') AND CONVERT(DATETIME, '2/11/2015'))

AND ActionType = 'Email'

AND Message LIKE 'Success%'

AND Message NOT LIKE '%Alert Reset%'

AND Message NOT LIKE '%is Up%'

ORDER BY LogDateTime DESC;