Networker

Re: [Networker] Nsradmin

2007-08-14 13:45:19
Subject: Re: [Networker] Nsradmin
From: Darren Dunham <ddunham AT TAOS DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 14 Aug 2007 10:40:46 -0700
> I have output from nsradmin and would liek to import into Excel and have it 
> show up in colums....

This is not trivial.  In the general case, items can be multi-valued, so
putting them into a single cell would be difficult.

> For example i have my licenses...
> 
> type: NSR license;
>                         name: Dedicated Storage Nodes/1;
>                      comment: #########;
>                 enabler code: ####################;
>                      host id: ####################;
>              expiration date: Authorized - No expiration date;
>                    auth code: ################;
> 
> 
> and want it to look like in Excel with information under each column.....
> typenamecommentcommenthost id

At least licensing should be pretty straightforward.

For the long answer, try
http://listserv.temple.edu/cgi-bin/wa?A2=ind0504&L=NETWORKER&P=R3545

For a quick attempt that might give you data in some cases, this might
work:

perl -ne 'chomp; s/^[^:]*:\s*//; s/;.*$//; if (/^\s*$/) { print "\n"; next; } 
print "$_,"; ' <nsr_output_file>

This is a quick hack.  It will *not* handle continuation lines where the
line laps over and is extended on the next with a backslash.  The more
general parser will handle it.

-- 
Darren Dunham                                           ddunham AT taos DOT com
Senior Technical Consultant         TAOS            http://www.taos.com/
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>