Hi All, Hi everyone, I hope you all are doing well. Currently I'm trying to have a Dashboard in my enviroment to display the number of Active alerts between Critical Alerts and Warning Alert, but for some reason that I cannot see in my code it is not bringing the correct numbers of active alerts for each of them. Would…
Hello, I was wondering if anyone can help me customize a report for me. I'm not good at SQL or SWQL, so I used co-pilot for the answer. Co-pilot did give me a basic report to start off, but I would like to add custom properties to the report and when I tried, it errors out. I'm looking for a report that shows all nodes…
I'm getting following error in the middle of running script. This collects running configs from NCM: 2025-02-04 10:31:27 [SERVERNAME] NetworkAutomation: app:backup_archive function:_node_is_active_on_backup_archive module:backupmanagement severity:DEBUG user:tool message:"Node is active" 2025-02-04 10:31:27 [SERVERNAME]…
Hey, I have a question and was wondering if I could get some guidance. I'm in the process of trying to create a new dashboard (Classic). I tried breaking each column by Device Type (Server, Network, Storage, Hardware Health Overview). I went into edit on each column and tried to some basic SWQL queries like…
I am trying to export Modern Dashboards to my SolarWinds HCO 2024.4.0 server. I have downloaded the func_ModernDashboards.ps1 and Modern Dashboards .json files. In PowerShell 7.4.5 I am running into an issue connection to my SolarWinds HCO 2024.4.0 server. Getting ParserError: 'You must provide a value expression following…
Hi According to CHATGPT it is possible to use nesetd "case-when" with MSSQL(code example below). Do you know if this can work some how with SWQL? SELECT CASE WHEN COUNT(CASE WHEN state = 'critical' THEN 1 END) > 0 THEN 1 -- If there's at least one Critical alert, return 1 WHEN COUNT(CASE WHEN state = 'warning' THEN 1 END)…
Here is my query: SELECT DISTINCT Community as Test FROM Orion.Nodes UNION ( Select DISTINCT RWCommunity as Test FROM Orion.Nodes) I was looking for a function to resolve this error, but I wasn't able to find anything at https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions This was a test to demonstrate the error, as…
Since the GUI is falling to associate a policy to a policy report I am trying to use the API. Struggling to find information on how to accomplish this simple task. The schema doesn't help much, we have the partitions not the music. I am looking at Cirrus.PolicyReports and AddPolicyRule. I see Cirrus.PolicyAssignment. I…
Hello! First time poster. I have what feels like a complicated ask (hopefully it's not and i'm overthinking it) and would like to gain insight or assistance coming up with the best way to go about this. I work at a company with 1100+ sites. Each site should have multiple switches, firewalls, security panels, DVRs, etc. I…
Hi fellow IT brothers, I posed this question a year ago on THWACK and received 2 responses. Although I appreciate all support it did not provide the guidance I needed. I must of explained it incorrectly. I will endeavor to correct this and re-write my requirement's now. Overall project goal: I'm in essence developing…
It looks like you're new here. Sign in or register to get started.