Hi, I'm trying to generate a chart showing the total number of bytes transferred over specific interfaces on a monthyly level. I can grab this info from Orion.NPM.Interfacetraffic. I'm having trouble figuring out how i can sum all the bytes based on the time stamp though. My query is: SELECT DATETRUNC('month', DATETIME) AS…
I'm trying to tweak our nodes down resource to add the date/time the system went down. I'm trying to figure out why it is listing all the times the nodes have went down and not just the most recent. Here is the query: SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],…
Trying to create a custom query widget in Node Details, Interface details, etc. in which the query results only reflect that specific object. For example, in the following query, when I bring up Node Details for Host A, the widget should show only Host A interfaces automatically. When I bring up Host B node details, only…
Hello, I posted this question a bit ago and didn't get a response, so I am trying again for some help. I have a handful of availability reporting widgets on a modern dashboard that report based on type of site or report overall average availability for all sites for the current and past month. When I originally implemented…
Hi all, I have got Solarwinds setup where we have Authorisation roles configured based on AD groups. A few users who belong to the same AD group and got the same privileges are not able to access the SWIS API via curl or python, but others in the group can. These users are also not able to login to SWQL Studio too. They…
we had a need recently to know what versions of products where installed across the Orion environment and found that there's currently no one place to find it, fine if only have 2-3 servers but when have a greater number and multiple Orion modules gets more complicated. Ended up with a small query to read the information…
I am using a case statement to display text in a KPI widget when certain criteria is met. I would also like to have that text or the background change color depending on the criteria. In the classic dashboards you could save a case statement with formatting like color:red;font-weight:bold as [_stylefor_name]. Is there…
Hi, Is there any way to add asset inventory via SWIS? Like using create or invoke methods. If possible, can you give an example?
Hi folks, I am implementing an integration with our CMDB. Trying to discover new server nodes added on CMDB. Nightly the my perl script is connecting to CMDB and Solarwinds DB, finding differences, if needed updates some custom properties or discovers new nodes. Everything is going as it was planned with snmp devices (AIX…
I have been working on automating the node creation in my org. I am running a single test case to test the functionality and running into a snag. The issue I am running into is that I have followed the steps carefully to create the node, I am adding the specific pollers I want for the node, adding the interfaces, adding…
It looks like you're new here. Sign in or register to get started.