Server IP & Port assignement database software?

a2vr6

Weaksauce
Joined
Aug 6, 2006
Messages
104
This question is more geared towards network admin's. I am currently using the old fashioned excel spreadsheet to keep track of IP and Port asssignment's whenever we setup a server in our data center. Curious what other options that are out there that are either free or low cost to take up such daunting and time consuming task. Basically looking for the following:

-More than one user able to work in updating IP and ports at time
-instantaneous updates to the document/sheet
-locking of fields when information is being updated.

Any info would be greatly appreciated.
 

mobiux

2[H]4U
Joined
Jul 24, 2000
Messages
2,626
if you've got excel going, you should be able to setup a small access database to do that.
pretty simple from what you've said you wanted in it. plus you can import your existing information.
 

a2vr6

Weaksauce
Joined
Aug 6, 2006
Messages
104
So creating an access DB will allow me to lock fields when there is more than one person updating data within in it?
 

moetop

[H]ard|Gawd
Joined
Apr 8, 2004
Messages
1,471
How many servers are you managing? If it's over 20 I would look to automate the process. Maybe create a cron event to dump a netstat to a text file and then parse it for the information.
 

a2vr6

Weaksauce
Joined
Aug 6, 2006
Messages
104
Yes it is alot more than 20 servers, it is also a mixed environment (Unix/WIndows). Netstat would not give me port info though.
 

moetop

[H]ard|Gawd
Joined
Apr 8, 2004
Messages
1,471
Netstat does give port info as well as the application using that port if you use the corect switches.

Try a netstat -a -b -n in windows
and

netstat -v in Unix..
 

Fint

[H]ard|Gawd
Joined
Jun 11, 2004
Messages
1,046
I read the OP to mean switch port (i.e., blade 5, port 48, or Fast0/35), not TCP ports.
 

moetop

[H]ard|Gawd
Joined
Apr 8, 2004
Messages
1,471
I read the OP to mean switch port (i.e., blade 5, port 48, or Fast0/35), not TCP ports.



AHHHH. I Didnt guess this as we keep track through port descriptions on the switch itself.

In that case it would help to know what type of switches he has?

What equipment are you working with? Cisco? If so then CiscoWorks has this built in. It's called User Tracking.

Oputils is another one (Switchport mapper tool in the suite). About $300 for the version that has "switchport mapper", but it looks like it supports equipment other than Cisco. It's also is a lot more than just a switch port mapping application.

Of course this only applies to networks with Managed switches.
 

Xipher

2[H]4U
Joined
Mar 15, 2004
Messages
2,621
All the stuff we are using is developed in house, tracks what the hardware is, rack, switch, port number, IP address allocations, OS and software, and notes. This is all for a dedicated hosting company and we are in 3 different locations so it also includes the data center as well. done with PHP and MySQL. All entries are done using the interface by techs.
 

a2vr6

Weaksauce
Joined
Aug 6, 2006
Messages
104
AHHHH. I Didnt guess this as we keep track through port descriptions on the switch itself.

In that case it would help to know what type of switches he has?

What equipment are you working with? Cisco? If so then CiscoWorks has this built in. It's called User Tracking.

Oputils is another one (Switchport mapper tool in the suite). About $300 for the version that has "switchport mapper", but it looks like it supports equipment other than Cisco. It's also is a lot more than just a switch port mapping application.

Of course this only applies to networks with Managed switches.

We mainly use Cisco hardware but there is some Nokia switches thrown in also.
 

Qualm

Gawd
Joined
May 31, 2003
Messages
562
Well I tend to document all my clients visually, so I use a combination of Visio (Professional 2003 currently) and tables in MS Word documents. I've done everything from 6 person LANs to 150+ server colo cages with these tools, nothing beats a diagram with every relevant detail taped to the inside of a rack enclosure door when you haven't seen the contents in 6 months.
 
Top