All, I am looking for some SWQL/SQL code that can pull out the following information from the database.
Columns Include:
- Device Name
- IP Address
- Time Down
- Time Up
- Minutes Node was down
All, I am looking for some SWQL/SQL code that can pull out the following information from the database.
Columns Include:
You can use this query as an SWQL report or as a Query Widget. It is excellent as a widget as it includes hyperlinks. Credit to the original creator for adding all the comments!
select n.caption as [Device…
OK... the start of this query was online somewhere...i have made it my own... OF COURSE>>>>> IF YOU USE THIS IN A LIVE ENVIRONMENT, it is not supported by SolarWinds! USE AT YOUR OWN RISK…
Just be forewarned that the "Events" table (one of the sources of this query) typically does not have the same historical settings as the Response Time details tables.
Are you trying to run this query in SWQL Studio?
When I try to run his Query in SWQL Studio I get an error
for your error... try changing 'Nodes.' to 'Node.'
have you tried my query above?
It didnt work, same error.
Before using i have removed any custom property, actually I am trying to convert this script as SQL one. As that the requirement.
In swql, verify your tables...
for the error posted above you must either comment or remove line 7 from the query. It is referencing a custom property that you likely do not have,
Yes I tried yours and its working, but failing to validate the out put of query to actual events on the nodes. I am finding that there is different in actual down event on the device when I see it from the console. Still validating
Hi, I am getting error on line number 18 where its saying invalid column name node, custom property I have already removed
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.