Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > User Device Tracker (UDT) > Unused Port Report with Admin and Oper status included

Unused Port Report with Admin and Oper status included

Table of contents
Created by Eric Bryant, last modified by MindTouch on Jun 23, 2016

Views: 340 Votes: 1 Revisions: 6

Overview

This article describes how to create a custom report (that includes operational and administrative status for each reported port) in report writer or SQL query for Unused ports.

Environment

All UDT versions

Steps

  1. Open the Report Writer program on the Orion server.
     
  2. Click Create a New Report.Reportwriter.PNG
     
  3. Run the following query in an Advanced SQL Report:

SELECT  

 UDT_UnUsedPorts.NodeID AS NodeID,  
 UDT_UnUsedPorts.PortID AS PortID,  
 UDT_UnUsedPorts.DNS AS DNS,  
 UDT_UnUsedPorts.IP_Address AS IP_Address,  
 UDT_UnUsedPorts.Name AS Name,  
 UDT_UnUsedPorts.PortDescription AS Port_Description,  
 UDT_UnUsedPorts.DaysUnused AS DaysUnused,  
 UDT_Port.PortID AS PortID2,  
 UDT_Port.AdministrativeStatus AS AdminStatus,  
 UDT_Port.OperationalStatus AS OperStatus  
FROM UDT_UnUsedPorts  
INNER JOIN UDT_Port  
 ON UDT_Port.PortID = UDT_UnUsedPorts.PortID     
WHERE  
 (  
  ISNUMERIC(UDT_UnUsedPorts.DaysUnused) = 1  
  AND CAST(UDT_UnUsedPorts.DaysUnused AS INT) >= 30  
  OR UDT_UnUsedPorts.DaysUnused = 'Never'  
 )  
 AND UDT_Port.AdministrativeStatus = 1  
 AND UDT_Port.OperationalStatus = 2  

Last modified

Tags

Classifications

Public