TerryHarding ✭✭✭✭✭

Something like this, maybe: SELECT sn1.Caption AS SourceNodeName, si1.InterfaceName AS SourceInterfaceName, sn2.Caption AS MappedNodeName, si2.InterfaceName AS MappedInterfaceName, tc.Layer_Type FROM [dbo].[TopologyData] td LEFT JOIN [dbo].[Nodes] sn1 ON td.SourceNodeID = sn1.NodeID LEFT JOIN [dbo].[Interfaces] si1 ON…

"If HTTPS is used, valid certificates are required. If self-signed certificates are used, you must install the necessary SEM certificates on the server running SolarWinds Observability Self-Hosted before you establish the connection."

Sorry - didn't ask what type of Dashboard - Modern Dashboard or Classic? If it's a modern dashboard Widget properties as above. If it's a Custom Query in a Classic dashboard: SELECT CONCAT(' ', N.Caption) AS [Node], -- Use CONCAT to Add spaces before Node Name for Icon spacing CONCAT('/NetPerfMon/Images/Vendors/', N.Icon)…

Expand the Properties and formatting section for the column where you want to display the status icon and select Status for Icon

Have you seen the below: solarwindscore.my.site.com/.../Set-up-and-test-Kiwi-Syslog-integration-with-LEM

documentation.solarwinds.com/.../core-sql-server-configuration-best-practices-sw1430.htm

In Database Manager, [dbo].[Containers] In SWQL Studio, Orion.Container

The Polling Method is for statistical polling. Availability is by default ICMP ping and it is this which is reflected in the green status. So, although it is unable to collect SNMP statistics, SolarWinds is able to ping the Node, so it shows as Green (Up)

I suspect it would complete one upgrade at a time. It seems what you need is a script to pre-stage the firmware files ready for the job to run for all devices during your maintenance window. I suspect you'll need to look outside of SolarWinds to achieve that.

When a firmware upgrade operation runs, the nodes targeted by that operation are upgraded one at a time, sequentially. In Firmware Upgrade Settings, you can limit simultaneous upgrades:

Hi Jason, Add the Custom Property filter to the end where clause: SELECT TOP 10 n.Caption ,aggSub1._avg AS Orion_CPULoad_AvgLoad_avg ,n.DetailsUrl ,n.Status ,n.LastSync FROM Orion.Nodes n LEFT JOIN ( SELECT i.NodeID ,i.InstanceSiteId , avg(i.AvgLoad) AS _avg FROM Orion.CPULoad i WHERE (i.DateTime > ADDHOUR (-1,GETDATE()))…

Unfortunately for you it will need re-installation of both Servers. The installation for a Main Poller is different to an Additional Poller. They cannot simply swap roles. You will need to uninstall the software from both pollers, then follow the below guide to migrate to the new configuration:…

Hi, Could I get you to mark it as answered, please?

It depends what the widget is. You can add a Custom Query widget to the Classic Dashboard and use the SWQL behind the Modern Dashboard Widget to present a table, but if it's a graphical Widget, the answer is no.

See the section how to add interfaces on a Node in https://github.com/solarwinds/OrionSDK/wiki/How-to-specify-interfaces%2C-volumes%2C-hw-sensors%2C-applications%2C-components-to-be-monitored-on-a-Node The key line is "Manageable": true,

Hi Alan, It depends what you are alerting on. Generally ${N=SwisEntity;M=Status} will give more detail. A useful list of variables can be found here: solarwindscore.my.site.com/.../Commonly-Used-Alert-Email-Variables

This is a direct upgrade and should cause no issues. Documentation for upgrade here: https://documentation.solarwinds.com/en/success_center/orionplatform/content/install-centralized-upgrade-primary-server.htm Ensure you have a full backup of your databases and snapshots of your Polling engines prior to upgrade so that you…

Hi Robert, CLI.DeviceTemplates in SWQL Cli_DeviceTemplates in SQL Regards, Terry

The upgrade should be straightforward (https://documentation.solarwinds.com/en/success_center/orionplatform/content/install-centralized-upgrade-primary-server.htm) and only involves one step. Ensure you have a backup of the databases and a snapshot of your polling engines prior to upgrading so that you can backout if…

SELECT ROUND(AVG(orion_responseTime_availability_avg), 2) AS Net_Avail FROM ( SELECT TOP 2000 aggSub._Avg AS Orion_ResponseTime_Availability_avg, n.CustomProperties.CoreProductionSystem FROM Orion.Nodes n LEFT JOIN ( SELECT i.NodeID, AVG(i.Availability) AS _Avg FROM Orion.ResponseTime i WHERE (i.DateTime > ADDDATE('day',…

See the below article to change your Device details: solarwindscore.my.site.com/.../Configure-Vendor-Machine-type-when-Orion-is-unable-to-detect-it

Hi, Is the Local Administrator account you are using Local Admin on the target Server? Try using the WBEMTEST Tool to test access. It may help you to understand where the issue lies: solarwindscore.my.site.com/.../Testing-WMI-Connectivity

Hi Dave, Try this as a starter: SELECT v.Name AS [Virtual Machine Name], s.Name AS [Snapshot Name], s.DiskFiles.Name AS [File Name], s.DiskFiles.size AS [File Size], s.DateCreated AS [Date Created] FROM Orion.VIM.Snapshots s JOIN Orion.VIM.VirtualMachines v ON s.VirtualMachineID = v.VirtualMachineID

The installer will install all SolarWnds products, however you can choose to only license the NCM product, leaving just NCM and the SolarWinds Platform Core. SQL Express is not recommended for production environments.

Enable Session Trace: solarwindscore.my.site.com/.../Generate-session-trace-logs

Hi Jason. A few issues. InterfaceID is not a column in the Orion.ResponseTime table, Interface Availability is reported in the Orion.NPM.InterfaceAvailability table.Separate queries would work as Custom Queries on the Node Details and Interface Details Views: SELECT ROUND(AVG(Availability), 2) AS [Availability] FROM…

An old post, but may point you in the right direction - thwack.solarwinds.com/.../84822

solarwindscore.my.site.com/.../Back-up-the-F5-UCS-file-in-NCM-7-5-and-other-binary-files-such-as-tgz-and-tar

Check the ConfigurationWizard log file in C:\ProgramData\SolarWinds\Logs\Orion.

Thanks. Ran into the same. Had me scratching my head!