nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Help with SQL query

rocco_2016

I need to report on a certificate expiring within 30 days that is unreachable due to SW platform being none internet facing. But the cert resides on a node within my SW platform. I have created a script within NCM, executed successfully and have the output within the NCM_Jobs table in the JobLog column. With the output of

sh crypto ca certificates replaced.asdfg_Jul-27 | i end

end date: 06:56:26 UTC Feb 18 2027

I'm struggling to do a date calculation for the 'within 30days' after getting the NCM Job details narrowed down.

Anyone managed this or can see what I need to add to create SQL or SWQL alert. Thanks in advanced.

Find more posts tagged with

orion

ncm

Comments

cnorborg

Have you looked to see if there is an OID that corresponds to this value that you can poll instead? Much easier than parsing that table if it exists… Set up a Custom Poller at that point and go that route.

Quick Links

PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…