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

Getting an SQL error when trying to get a data from syslog table

Hi All, I am trying to create query on syslog and Nodes table to get the data for how many devices syslog are storing for specific device type from Custom properties .

Select IP, Message from syslog where NodeID IN ( Select NodeId from Nodes Where devicetype = 'typename')

but I am getting attached error and I can see that data is present for the customproperty.

Any help will be appreciated, Thanks in advance.

Syslog_error.PNG

Find more posts tagged with

syslogs reports sql query

Accepted answers

All comments

bhupeshwalde

I filter the criteria but still that was not happening, finally i change the condition only for the specif dates and it started giving me an device list.