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 Ports Population Information

Unused Ports Population Information

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

Views: 112 Votes: 1 Revisions: 6

Overview

This article explains the nature of a 'Unused Ports' resources and reports. 

 

Environment

  • All

Detail

 

There are 'canned' reports for unused ports report that pulls from a view not a table called 'dbo.UDT_UnUsedPorts'. (View cannot be seen from the Orion Database Manager)

 

This view has the following columns:

NodeID -- (Node associated with port)

Caption -- (Node Name associated with port)

DNS -- (Hostname of Node associated with port)

IP_Address -- (IP address of Node associated with port)

PortID -- (PortID of Port)

Name -- (Name of Port)

PortDescription -- (Description of Port)

DaysUnused -- (Days the port has been unused)

 

The biggest key to this view is that it changes the DaysUnused column from 'Never' to a numerical count based on last usage. This view is populated when a port with a current endpoint(s) has all of those endpoints moved into historical data. At that time the view will update the DaysUnused column based off at date time conversion from current date compared to the date of the last connection and supply the difference. Operational status of the port has no bearing on this table and can be mistaken quite often as the port being in use when operational status or 'Active Status' is 'yes' or up.

 

 

 

Last modified

Tags

Classifications

Public