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

Report Designer - Advanced SQL question

I have a report that I would like to ask for some help in getting it to work the way it has in the past and hasnt since we applied the last upgrade.

SELECT TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,
Nodes.Vendor AS Vendor

FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE
( DateTime BETWEEN 40878 AND 40907 )
AND
(
(Nodes.MachineType = 'Cisco 3845' )
)
AND
(
(Convert(Char,DateTime,108) >= '06:00') AND
(Convert(Char,DateTime,108) <= '18:30')
)

My question is that at one time, my one 3745 router also showed up in this report and now doesnt. With my limited SQL knowledge (I can spell SQL), I havent been able to find a way to get the 3745 to also show up in this report along with the other 3845's. I know it has to be something simple. I have tried doing it myself using a OR command and the 3845 syntax changed to reflect the 3745 but all that did was thoroughly trash the layout of the report.

Thanks,

Ron

Find more posts tagged with

Accepted answers

njoylif

replace that line with:

(Nodes.MachineType Like 'Cisco 3[7,8]45')

All comments

tomas.mrkvicka

Hi,

it can be for various reasons. First of all - is there any node with MachineType = 'Cisco 3845'? You can check it by executing this query:

SELECT NodeID FROM Nodes WHERE MachineType = 'Cisco 3845'

If there are some results then you should check data in ResponseTime view. You should start by elimination of unnecessary conditions. For example use only following WHERE conditions in your query:

WHERE (Nodes.MachineType = 'Cisco 3845')

If there will be any result then add DateTime to condition etc.

njoylif

replace that line with:

(Nodes.MachineType Like 'Cisco 3[7,8]45')

RonaldNutter

Thank you, oh report guru !

You were interpret what I worded so poorly. That fixed the problem. I now see all of my 3845 routers and the one lonely 3745.

Ron