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…
Hi Is it possible to add component in existing template with the SDK or even SQL query? Thanks
It looks like you're new here. Sign in or register to get started.