[164937] in North American Network Operators' Group
Re: IPAM
daemon@ATHENA.MIT.EDU (Raj Jalan)
Mon Aug 12 13:13:12 2013
In-Reply-To: <9FFA8B2148100D40969011DAEEB56FD00266C9DF0B30@server.fasttrackcomm.local>
Date: Mon, 12 Aug 2013 13:12:37 -0400
From: Raj Jalan <raj@rajlog.com>
To: Natambu Obleton <nobleton@fasttrackcomm.net>
Cc: "nanog@nanog.org" <nanog@nanog.org>
Errors-To: nanog-bounces+nanog.discuss=bloom-picayune.mit.edu@nanog.org
If you are using Postgresql with Northstar, you should be able to export
data to csv with a command like following:
COPY table_name TO '/tmp/file_name.csv' DELIMITER ',' CSV HEADER;
If you are using mysql as your DB in Northstart, you can do something like
this to create a CSV file:
SELECT *
INTO OUTFILE '/tmp/file_name.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM table_name
Once you create the csv file, most of tools can import it. One more tool to
checkout is device42(http://www.device42.com) which has extensive import
and auto-discovery options.
On Wed, Aug 7, 2013 at 12:41 PM, Natambu Obleton <nobleton@fasttrackcomm.net
> wrote:
> I have customer that we deployed Northstar for their internal ip
> management over 8 yrs ago. They are still using it, but it is slowly
> breaking on them. Can someone recommend an IPAM solution that has a
> Northstar import option? They have hundreds of entries detailing customer
> who was assigned the ip address and I would like to avoid any data
> massaging. TIA
>
>
>
> --
>
> Natambu Obleton, CISSP CCIE
> Senior Network Engineer
> FastTrack Communications, Inc.
> 970.828.1009
>
>
