I'm terrible at SQL and I'm trying to learn SWQL this year. Examples go a long way for my learning. Can someone give me a basic SWQL query to list nodes and filter by node custom property? I believe the data I want is in Orion.Nodes and Orion.NodesCustomProperties. I see there is a link but I'm unclear how to get what I…
Hello I am new to Solarwinds. I have some SQL and Powershell experience. I am trying to get a powershell connection established but I am running into this error. -ERROR- Get-SwisData : Identity check failed for outgoing message. The expected DNS identity of the remote endpoint was 'SolarWinds-Orion' but the remote endpoint…
Does anyone know of a way to use active directory credentials to work with the API? Local accounts work, however I get a 403 client error when trying with AD credentials. URL is server:17778/.../Query
Hi, I've got a requirement for SMS integration for alerts. Basically, whenever there's an alert for nodes, the trigger/reset of the alert needs to execute an action that makes an entry into SMS DB table. Then SMS agent installed on the DB server will grab the entry and relay the entry to SMS service provider. I believe I…
Basically I have a report that is emailed out in PDF and CSV format from SolarWinds to a couple of other user and platforms. Is there an API that can initiate the build of the report contents. I would have an agent that would make an REST API call to SolarWinds. I am also looking for a solid example preferably with Curl.…
Hi Need help to insert " AddHour +5 " in Uptime result SELECT Nodes.Caption, Nodes.IPAddress, AddHour(+5,StartTime.EventTime) AS DownTime , nodes.status,AddHour(+5,LastBoot) AS LastBoot , ncp.ATM_Branches , ( SELECT TOP 1 EndTime.EventTime FROM Orion.Events AS Endtime WHERE ( EndTime.EventTime > StartTime.EventTime) AND…
I am a newbee for both networking and SolarWinds. I am working in a global enterprise and have been tasked with building a C-level Network dashboard however I just learned that we have 70+ instances of SolarWinds. Can you build a dashboard that connects to multiple SolarWinds Databases?
We're trying to find a way to import some information from Solarwinds into Grafana. I am not a developer, and I've been tasked with just generating the key. Unfortunately, I am never given a straight answer when I open a ticket with Solarwinds as to what type of key needs to be generated. Thank you in advance for your…
I want to see syslog entries that have triggered the alert, but the swql studio AlertMessage table seems to be greyed out and nothing returns when I query the table
Hi iam trying to get node Down Time and Node Availability for Today Period. But Down Event time and Availability is showing wrong data. My Requirement: Date = always today's date ( start time 12 AM AND end time on which time query executed. ) Down Event = last time when down event generated. SELECT TOP 10…
It looks like you're new here. Sign in or register to get started.