Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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 on Aug 26, 2016

Views: 11 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