I'm trying to create a report of all Orion node that are NOT in NCM and not a member of a particular group. I have the first part tackled, but struggling to figure out how to exclude node that belong to that group. What I have working so far: SELECT Caption FROM Orion.Nodes orionnode LEFT JOIN NCM.Nodes ncmnode ON…
Hi I "think" it's not new "issue" I don't see a way to Audit if API user is log into or not..or what Query is running I have some TS integration that are not working (all the time :-) )
Orion_IsSessionExp is True . How to make it false or change expiration date. As We added second web server in Load Balancer F5 but after adding in Load balancer its shows The Session Time Out after Few Minutes around (10 Min). We check in Cookies Orion_IsSessionExp is true and its date shows previous date.
Hi community, I have been trying to change a system display name in the NPM console but I can't find the right method on the Solarwinds API to do so. Here's my code snippet: swis = SwisClient(server, username, password) results = swis.query("SELECT Uri FROM Orion.Nodes WHERE NodeID=@id", id=9) swis.update(uri +…
Hello, I'm currently looking into automating the background image uploading for Orion Maps (since it doesn't support background image from URL). From taking a look at what network requests are made when an image is uploaded it looks like "https://<solarwindsServer>/api2/maps/v1/assets/images" is the correct address to post…
Hello Thwack, Is it still accurate that in SWQL you cannot convert a string to an integer? I have the need for a custom alert and am trying to determine if I could achieve it via SWQL, or need to go with SQL. Just wanted to ask and see if the below thread (and the github documentation) would still be accurate.…
We have the query below that seems to have stopped working. I haven't been able to find a new table in the Stored Procedures that seems like it might be similar. Is there a SWQL equivalent we should use instead? These three seem to not be reconized in SQL and the query doesn't work. dbo.GetInBps95th(InterfaceID,…
Hi, I am trying to join Orion.nodes table with Cloud.Azure.Instances on NodeID. However, in few of my nodes, the NodeID is showing Null which leads to incorrect output. Here's my below query: SELECT n.CloudInstance.DisplayName AS Nodename ,n.IPAddress ,n.CPULoad ,n.PercentMemoryUsed ,n.StatusDescription ,n.DetailsUrl…
Hi, I am apologizing in advance if my post is not on the right channel/thread. I'm a beginner at SWQL and have no knowledge of SQL. I just want to create a modern dashboard with Downtime, Uptime, and Total hours down. I've been reading articles here in the forum but what I collected were in parts and I don't know how to…
Hi there, Source file containing Custom Properties is in C:\Make\cp_updates.xls This file contains IP, cp1, cp2. I need to update Orion's CPs, matching by IP, using the values in the spreadsheet, but also have provisions built in for a cp3, cp4, cp5 etc, should it be added in the future. This needs to be as failsafe as…
It looks like you're new here. Sign in or register to get started.