Tools that Work

1
Tools that Work

• At Umass-Amherst
• Scott F. Conti
• Network Operations Manager
• Scott_at_oit.umass.edu

2
UMASS-Amherst Network Vital Statistics

• Class B network (umass.edu - 128.119)
• 142 buildings
• All 42 Residential buildings networked
• 8800 Residence hall connections (port-per-pillow)
• 5500 Academic building connections
• 900- Cisco 24 port Switches (1900 and 2900
  series)
• 5 Cisco 6509 core switches, 2 Cisco 5500 switches
• 600 Off-campus dial-in modem lines
• DS-3 (45mb/s) commodity Internet connection
• DS-3 - Internet2 connection

3
How do we find the port ?

• Lookup IP address in DHCP server logs
• Search switches for MAC address in switch CAM
  tables
• Lookup Jack activation record in Remedy database
• jacktrack database
• Netreg database (students)
• Verify correct jack
• check Email logs if necessary

4
./quickfind 128.119.123.198 searching for
haml-198.res.umass.edu. (128.119.123.198) Enet
address for 128.119.123.198 00e098024c69 Che
cking if haml-198.res.umass.edu. is
operating....host IS operating. 19XX, ignoring
ports 25(AUI), 26(A), 27(B) 00e098024c69
found on haml-sw-210-1, 21 getting room number
from OIT/NSS Jack Tracking 000000000013649... Buil
ding and Room HAML 427
1 Building
HAML 10 Switch Port 21 2 Room Number
427 3 Jack Number 4-1-21 4 Jack
Letter C 5 Last Name TUTHILL 6
First Name RICK 7 Phone Number
5-9726 8 UMAccess acct tuthill 9 Name
haml-sw-210-1
1 Building
HAML 10 Switch Port 13 2 Room Number
427 3 Jack Number 4-1-21 4 Jack Letter
D 5 Last Name MISRA 6 First Name
CHRISTOPHER 7 Phone Number 5-9721 8
UMAccess acct crispy 9 Name
haml-sw-210-4
IP address
128.119.123.198 Enet address 00e098024c69 L
ease Starts 1999/12/09 155906 Lease Ends
1999/12/14 155906 Lease Client "Mole"
5
Remedy Jacktrack system

• The Remedy AR (Action Request) system is used to
  manage all aspects of Jack activation for
  administrative jacks.
• Activates Switch ports immediately, or sends
  request to Cable Engineering for crosswiring.
• Support database lookups on any identifying field
• Provides real-time statistics on request
  processing.
• Allows movement of workflow through multiple
  departments.

6
Network Services Remedy Screen
7
Remedy Jacktrack Schema
8
Netreg

• Developed by Southwestern University
• http//www.southwestern.edu/ITS/netreg/
• Works by issuing a temporary non-routable DHCP
  lease until the user registers the MAC address of
  the machine.
• Spoofs all DNS queries to registration server.
• Once registered, user can obtain a normal DHCP
  issued IP address.

9
Netreg - Subnet Overview
10
Netreg Subnet Details
11
Netreg - Lease Information
12
Netreg User Information
13
Systool

• Systool is a web-front end that runs PERL scripts
  that parse the Cisco Log files.
• Router Tool queries router logs
• Dialup Tool queries AS5800 Access-server
  dial-in logs.

14
Systool Router Tool Query
15
Systool Router Tool
16
Systool Router Tool Top Ten
17
Systool Dialup Tool Query
18
Systool Dialup Tool
19
Incident Database - Console
20
Incident Database Query
21
Thank You !

• Scott F. Conti
• University of Massachusetts-Amherst
• Scott_at_oit.umass.edu
• 413-545-9625

22
Trend Top Talkers