Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > SQL query to find mangled IP addresses

SQL query to find mangled IP addresses

Table of contents
Created by Norsolihati Selamat, last modified by Aileen de Lara_ret on Aug 26, 2016

Views: 18 Votes: 0 Revisions: 4

Overview

SQL query to find mangled IP addresses that do not have the correct number of octets, NULL or blank.

Environment

All Orion Core products

Detail

Use the following SQL query to find mangled IP addresses that do not have the correct number of octets, NULL or blank:

SELECT NodeID, IP_Address, Caption
FROM NodesData
WHERE IP_Address NOT LIKE '%.%.%.%' OR
IP_Address LIKE '%.%.%.%.%' OR

IP_address is NULL OR IP_Address = ''

 

 

 

Last modified
19:21, 25 Aug 2016

Tags

Classifications

Public