Hello, we are migrating to the SolarWinds platform. I want to create group and populate them using a csv file. I have created a custom property named _group. The filtering doesn't work. Groups are filled with every node. The excepted behavious is to the group populated with the matching name inside _group. Set-Location…
we required API Parameters for Device Performance, Device Fan, Power Supply. The API results would have to be customer specific can we have any refrence tables/columns for these data on SDK?
Hello guys, I'm trying to get the latest (last hour) conversations between defined hosts. For the purpose I use the following SWQL query: SELECT DestinationIP, Packets, SourceIP, TimeStamp , ObservationTimeStamp, IngressBytes, EgressBytes, TotalBytes FROM Orion.Netflow.FlowsByConversation WHERE SourceIP = 'X.X.X.X' AND…
Hi, I have a requirement to work on, where a user wants to see the list of all the nodes which is grouped by custom properties along with their status. I have below query that shows the count of nodes based on their custom properties and its status: SELECT n.CustomProperties.Comments, COUNT (CASE n.Status WHEN '1' THEN 1…
I am very new to SQL and SWQL and am hoping someone can help me with a query I'm building for a customer report. I started by using an application availability report for the last 30 days. I only want to report on 6 URL/HTTPS monitors I have setup for the customer and need to filter the result by using ApplicationID. I…
Am unable to use LAG function and Over clause in SWQL anyone help me
I've been looking at the schema: Orion.Alerts but the query: SELECT Description FROM Orion.Alerts WHERE AlertID = {alertObjectId}fails with: "Source entity [Orion.Alerts] not found in catalog" Is this normal? I can query from Orion.AlertObjects but not Orion.Alerts
I see several answers to other questions that reference how to do this via Powershell and I've tried to replicate this in a Python script using the REST API. {"uris": ["swis://server1.com/Orion/Orion.Nodes/NodeID=110"], "properties": {"UnmanageFrom": "2023-08-23", "UnmanageUntil": "2024-08-22"}} The request comes back with…
For the purpose, we want to use the API that SolarWinds provides. I'm not sure if I do something wrong in the query, but I don't know how to specify the = part from the query into the url that is provided. For example, the documentation suggests format as it follows: localhost:17774/.../Query i'd like to create the query…
So I am trying to see how far I can take the rest api for the network discovery. I have found the below links as well as a few on thwack that all pretty much have about the same level of information. * https://github.com/solarwinds/OrionSDK/wiki/Discovery *…
It looks like you're new here. Sign in or register to get started.