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

Need a little SQL help

My SQL is very rusty, been way too long since I last did queries in MySQL. What I am looking to do is create a report based on a SQL query for response times(or other columns) for certain node ID's.

So I did a

SELECT * FROM [dbo].[NodesData] WHERE NodesData.Caption LIKE '%XA-%'

This gave me a list of the nodes I want to query, now I need to take those node ID's and match them to the ResponseTime column in the Node Statistics table, and that is where I get lost. I haven't done a multi table query is so long that it is all gobbly to me again.

Find more posts tagged with

Accepted answers

wluther

ACDII Yes, you are correct, you will need to join the two tables by "NodeID".

Here is an example of how you can join both tables.

SELECT TOP 10nd.NodeID,nd.Caption,nd.IP_Address,ns.ResponseTimeFROM dbo.NodesData AS ndJOIN dbo.NodesStatistics AS ns ON nd.NodeID=ns.NodeID

You can now use "ns." to pull/filter the data in the NodesStatistics tables.

Thank you,

-Will

All comments

wluther

ACDII Yes, you are correct, you will need to join the two tables by "NodeID".

Here is an example of how you can join both tables.

SELECT TOP 10nd.NodeID,nd.Caption,nd.IP_Address,ns.ResponseTimeFROM dbo.NodesData AS ndJOIN dbo.NodesStatistics AS ns ON nd.NodeID=ns.NodeID

You can now use "ns." to pull/filter the data in the NodesStatistics tables.

Thank you,

-Will

ACDII

YES, that is a great start. I can pull up those nodes, so now just a matter of tweaking the tables to report what I am looking for. Thanks!

i_like_eggs

im on my phone at the monent lol. everything joins primarily throuh the nodeid i cant test the follwoing query but heres the idea

SELECT top 100 (*)

FROM nodedata ND

INNER JOIN nodes statistic NS ON ND.nodeID = NS.nodeID

Im just slecting top 100 here beacuse this could be a huge query.

i_like_eggs

from the time i saw this and wrote the answer Will answered and its already a correct answer lol nice one

ACDII

Yep, he got me what I needed and I was able to create several reports now. I got a new one this morning. I created a report to run weekly and got my first emailed pdf. I now have a very nice PDF of the login prompt.