Can SW add Last Month and This month to the SWQL graphical query builder quickpicks so I dont have to spend hours trying to figure out how to add this to my queries? I am not great at scripting and for KPI widgets I am only interested in this months or last months data, generally not the last x days data. Currently the…
So I've watched labs #86, 91, and 93. I've used the SWQL Functions on Github multiple times/ways. When modern dashboards came out they seemed bugged to me so I've waited a few years and now I figured I would give them a chance with this new deployment I'm working on, and I can say without a doubt they aren't a replacement…
Hi, I have a script on my system that moves two interfaces into a different VLAN and another that moves them back. I'd like to write a custom query that provides an indication on a dashboard as to which VLAN the interfaces are in and display a colour indicating this. I'm very new to SWQL. Is this possible and could anyone…
I have the below query which gets the output in microseconds , is there any way we can get the data in milliseconds please help me to customize\…
Dear Thanks for the great community i have the below query which fetches the data like memory used device name and cpu load etc , --------------------------------------------------------------------------------------------------------------------------------- SELECT TOP 50…
Hi everyone, First of all, I can get the data of a Solarwinds report manually with excel. but how can I do this with a script? Do I need to write a query with an api? I was able to export xml, but I could not find the report data in this xml file. My goal is to transfer these report data to elasticsearch with python script.
I'm trying to use linear bar charts in a widget to display overall capacity/used/free but cannot find the right object to query for it. I can find the DataStoreUsedSpace in Orion.vim.clusters but no corresponding datastore size. Weirdly it has that for CPU and MEM but nothing for datastore cap. Any ideas?
Hey everybody, currently we are implementing some automation in our enviroment. Our first idea is to mute and unmute our server in SolarWinds, when we have patches by our customers. The automation is build to schedule a mute from now to a week further. The Audit Events looking great. Now our Problem: On two patchdays the…
We are looking to integrate our 3rd party application with Solarwinds with REST API. Trying to test with the following query via POSTMAN but unable to retrieve any details from Solarwinds. https://<MainpollerIP>:17778/SolarWinds/InformationService/v3/json/Query?query=SELECT NodeID, ,DateTime ,AvgResponseTime…
Just this week, I'm encountering this error when opening SWQL studio: "don't know how to handle element properties" The tree-view wont expand or show any schema. I type something into the search and it hangs up. then it throws up a load of .Net errors This is the first time this week I've encountered this issue. Strangely…
It looks like you're new here. Sign in or register to get started.