The most recent content from our members.
I want to make custom report for orion syslog, but when i query to the syslog table then the table is empty. Anyone know in which table the orion stored the syslog messages?
Hi Need help on converting the SQL script below to SWQL. I got this SQL query from Wireless AP Availability for last month report and I would like to use the data in modern dashboard table which only supports SWQL. Thanks is advance! ------------------------------------------------------------------------- DECLARE…
I have been working on a SQL script that will pull the monthly average volume utilisation of a selected node for the past 6 months. What I have so far only covers a single month by matching the timestamp and I can't work out how to cover multiple months in the same script. SELECT vd.[NodeID],vd.VolumeID,v.volumedescription…
Hi all, I have defined an alert to trigger when Cisco interfaces change status to err-disable. The problem is the alert message is quite lengthy: CISCO-SYSLOG-MIB:clogMessageGenerated : sysUpTime = 316 days 16 hours 50 minutes 27.35 seconds, clogHistFacility.31909 = PM, clogHistSeverity.31909 = 5, clogHistMsgName.31909 =…
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 have version 2024.4.0 and Netflow I need to create a report with a custom table or custom graph using SQL. Both methods fail when attempting to hit the Netflow Database I'm trying to query my NetFlow database but keep getting a message that indicates the query is invalid. A basic query to the Orion database works. Select…
Hello everyone, I`m trying to build custom alert for BGR relations and I have problem with custom dynamic message in 'trigger actions' tab. I need to compare data from SWQL [SwisEntity] with IP address from Nodes table [SQL] and then re-translate it to Node name. My current message is below and the problem is highlighted.…
I have been asked as DBA to create a view querying some external data to Solarwinds that our Solarwinds team would like on one of their node dashboards. So far we have this data in the backend SQL Database as either a table or a view however we can not get it into SWQL Studio to be utalised in the dashboard. Is there any…
i am using the below sql query to fetch the asset details but i am not able to fetch - Software Version, Hardware, Node Category SELECT n.NodeID, n.Unmanaged, n.Caption, n.IP_Address, n.Vendor, hi.servicetag 'SerialNumber', n.AssetType, n.SnowModelCategory, n.SupportTier 'Effective Support Tier', 'No' 'StackMember',…
Hello, I have powershell script and the result store in 2 variables (message.kb and message.dt). Anyone know in which table both value stored? I need to make customization report to query both result using SQL.
It looks like you're new here. Sign in or register to get started.