nelsonlegacy · DevOps Specialist · ✭✭✭

Comments

  • @amore1329, I have zero issues with other members reaching out to me, especially about this solution. I'm working on dropping another article about operationalizing this feature, including dashboard SWQL, PowerShell integration, etc.
    in Automated FortiGate Firmware Upgrades in SolarWinds NCM Comment by nelsonlegacy 2:10PM
  • There's multiple ways you can solve this, but the slowness you're experiencing is because of the leading wildcard in your WHERE clause. You do WHERE l.Message = '%AAA Server Down%', and when you have a leading wildcard in a query, it has to search every single log entry in the database to check if they have "AAA Server…
    in SWQL to pull Syslogs when AAA Server Down Comment by nelsonlegacy October 25
  • This is all you need. I've used it extensively. import csv from orionsdk import SwisClient from requests.packages.urllib3.exceptions import InsecureRequestWarning import requests SOLARWINDS_SERVER = "" SOLARWINDS_USERNAME = "" SOLARWINDS_PASSWORD = "" CSV_FILE = r"" # CSV file requires columns IpNodeId, CustomProperty1,…
    in Update custom properties of IPAM subnet via SWIS (Python) Comment by nelsonlegacy October 25
  • I know it's a data engineering/data analytics solution, but you can definitely achieve this easily through SWQL by querying the Orion.OLM.LogEntry table. Use you WHERE clause to filter to Syslog only, and match any other specific message or node details you may require to pull the data you need. I do the same thing for our…
    in KSS NG - Add the possibility to export .csv file like we had with the legacy KSS Comment by nelsonlegacy October 25
  • I've achieved this same thing for my organization through an SQL analytics. You can find everything you're looking for in SolarWindsOrion.dbo.Nodes, but if you have less-supported vendors like we do, you can also create UnDP pollers for software/firmware versions and models, and join the data from…
    in Consolidated Inventory Report with Hardware and software details against host name Comment by nelsonlegacy October 25
  • Yeah, I just ran into the same issue myself. Came across this article after I found the setting in the DB causing the failure. Luckily I didn't go too far down the rabbit hole after I did some standard checks and confirmed the system was setup correctly to function at the application layer, but after some poking around and…
    in Fatal Error received with the Core Business Layer Comment by nelsonlegacy May 19
  • I know this is a bit of an old post, but I do have a resolution to this. I was able to use the SolarWinds SDK and write a PowerShell script that essentially uploads groups in bulk from a predefined CSV file. It’s intentionally “fill-in-the-blanks,” prompts for login, works with IP or hostname (use 127.0.0.1 if running on…
    in Import Predefined Groups Comment by nelsonlegacy September 2025
Avatar