-
How to find devices on SolarWinds where CPU, Memory and Interfaces are not added
Hello All Is there a way we can pull a list of devices on SolarWinds where CPU, Memory and Interfaces are not added? Devices discovered with SNMP but resources are not added. Can we do it through a SWQL/SQL query?
-
Modern Dashboards - add the ability to query via SQL
Currently when creating a custom widget on a modern dashboard the only option in the data model section is for a custom SWQL query. I would like to add the option to select either custom SWQL or custom SQL. This will allow more flexibility on the modern dashboards. If it is not possible to add it to the existing widgets,…
-
How to Query two tables?
Hello, I have no SQL or SWQL experience but I am looking for some guidance. I have been able to create the following Query SELECT TOP 10 NodeID, Address, Application_Arch, BusinessOwner, BusinessUnit, City, Comments, Company, ContactName, CoreDependencies, Country, Custom_Serial_Poller, DateAdded, DeviceDescription,…
-
Group based dynamic queries, custom properties and alerts
Hello, Recently I was working at assigning Nodes to proper Groups via IP based dynamic queries. It work well, however the regex support it could be better. Anyway, now I have around 30 groups with dynamically populated Nodes. Based on the Groups I'd like to set some Node Custom Properties now. However I can see that the…
-
Report or Widget to Identify any nodes not included in any map
Hello all again, thank you for all of your continued support! I am now looking to create a report or widget that will report or display all nodes which are not included in any Orion Maps. So far the only way I have been able to do this is through a very slow and inefficient report. I query every node ID and ask for its…
-
Long running reports
Hi, I saw multiple warning messages information service log stating long running queries which is taking longer than usual to execute and impacting website. WARN SolarWinds.InformationService.Core.InformationService - (null) (null) Support! -- LONG RUNNING QUERY: OperationContextId 60b6e459-4465-4a7e-94d2-a7be0ef6f77b -…
-
Multiple rows with SQL query in alert body?
Hi guys. Know about the old problem, when you can't just gather multiple rows and put it in alert body in easy way, but dunno how to solve it. So I have this simple query: SELECT TOP 10 * FROM APM_WindowsEvent_Detail INNER JOIN (SELECT ID as CID FROM APM_Component WHERE ComponentOrder=1 and ApplicationID = 728) CID ON…
-
Useful SWQL-queries - does anybody have a bit to share?
Guys, is there any repo/knowledge base with useful SWQL-queries exist? I got some from SDK docs, some I wrote myself and got a few from THWACK forums. But what if someone have a huge collection of them and ready to share? Believe it would be great for those who often use Solarwinds api or external systems integrated with…
-
EOC, SWQL AgentManagement tables not accessible to EOC
I left any custom properties out for the example: How can I get this information in an EOC report. in 2020.2 This SWQL query works at the Orion Server level. SELECT N.NodeId ,AMA.Name ,AMA.AgentVersion ,AMA.AutoUpdateEnabled ,AMA.RuntimeOSDistro ,RuntimeOSVersion, RuntimeOSLabel, OSLabel FROM Orion.AgentManagement.Agent…
-
Solarwinds Database Monitoring
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…