The most recent content from our members.
Hey Thwacksters! This report is handy, if you work with an Orion instance which manages client workstations. In many such environments, there is invariably a high turnover of equipment. It can quickly become difficult to work out which nodes have just gone down, and which ones have been down for a while, if there is a…
Hey Guys, Figured I would post this information here as I recently had to create a Custom Report for pulling back the Serial Numbers from Cisco 5500 WLC. This information isn't pulled natively by Solarwinds for some reason, so we had to create a custom Poller to query the SNMP OID for the Serial number and then select the…
The following SQL query returns 230: Select COUNT(*) AS 'NodeCount' FROM [SolarWindsOrion].[dbo].[NodesStatistics] WHERE [LastSync] < DATEADD(MINUTE, -1, GETDATE()) The following SWQL query against the same database within seconds of the first returns 42 which is incorrect: SELECT COUNT(*) AS NodeCount FROM Orion.Nodes…
Hi, I need the same output as the Top SQL statements by wait time graph, but in csv/xls format. To this end, I have been trying to extract the data directly from the database, but I am unsure of how to accomplish this. I thought the numbers in CON_STATS_SUM_ were what I needed, but when extracting data based off of it for…
Please consider allowing individual database servers or individual clients to be flagged as needing to compare full SQL contents (including any comments) when determining SQL uniqueness. Currently DPA appears to ignore contextual comments inserted into SQL queries and evaluates the core query. Consequently, If a query…
Hi Guys, Recently we created alerts to provide us with BGP Neighbor information I'm having a problem as such as when the SQL Query returns NULL values for neighbors that don't have the IP address in the database, instead of the alert displaying "nothing" if pastes the SQL query in the alert. Is this an issue within NPM or…
This is a quick SQL code to count the number of devices within a /24 subnet. I'm sure it can be expanded to accomindate any cidr. SELECT SUBSTRING(IP_Address, 1, LEN(IP_Address) - CHARINDEX('.', REVERSE(IP_Address)))+'.0/24' as [Subnet], COUNT(*) as [Count] FROM nodes GROUP BY SUBSTRING(IP_Address, 1, LEN(IP_Address) -…
All, I am trying to come up with a sql or swql that will show me all my devices in a region that are backed up verse those that are not being backed up. My custom property is "L1_Region" and my variables are [Asia, Pacific, US, and Europe]. Thanks, CourtesyIT
Hello - I am just looking for a simple answer - and NOT a complicated solution with sql triggers etc We have a custom field defined, I can see the values in the dbo.CustomPropertyValues table. When they're added from SolarWinds GUI, they're usable. I need to be able to add new values from a SQL query - but they don't show…
Forgive me if I have failed to find the answer elsewhere, but I'm curious as to whether or not node name or nodeID are accessible from within a SQL User Experience Monitor. If not, I could resort to wrapping the SQL in PowerShell because I know I have access to those node attributes as variables within a PowerShell…
It looks like you're new here. Sign in or register to get started.