Re: [Networker] <no subject> - Reporting on Storage Nodes & Clients

Conrad,

can you also send me a copy of you script? thanks

Bart 

-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On Behalf Of Conrad Macina
Sent: Wednesday, July 13, 2005 12:20 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] <no subject> - Reporting on Storage Nodes & Clients

I have a .ksh script that does something a little like what you
describe, which I'll send to you off-list. Here's what it does:

# report_on_clients -?

report_on_clients Lists all clients configured on this server, showing
client name, OS type and date of last backup.

Usage:   report_on_clients [-c file.csv [-f]]
Options: -c =  Produce .csv (comma separated variable) output in named
file
         -f = FTP CSV file to <our data collection server> (requires -c
option)

With the -c option, the script produces a .CSV file consisting of the
following information for each client:
Client,Server,Primary Storage Node,OS Type,Last Backup Date,Time

You could probably import that into Excel and sort by storage node. It's
working under NetWorker 7.1.1.

Conrad Macina
Pfizer, Inc.


On Tue, 12 Jul 2005 10:46:19 -0400, Brian Greenberg
<bgreenberg AT GLASSHOUSE DOT COM> wrote:

>Does anyone have a shell script that would generate a report of all the
storage nodes on an nsr server and all the clients for that storagenode
that I could easily import into excel?  I'm having a heck of a time
trying to derive the syntax for nsradmin.  Any help or pointers to
resources that would help me with nsradmin shell scripting would also be
appreciated.
>
>I'm trying to generate a report that would give me something like this:
>
>NSR Server   StorageNode    Client(s)
>server1      sn1            client1   client2   client3   client4
>             sn2            client5   client6   client7   client8
>
>Any help would greatly be appreciated.
>
>---
>Brian J. Greenberg
>bjgreenberg AT gmail DOT com
>bgreenberg AT glasshouse DOT com
>
>
>--
>Note: To sign off this list, send a "signoff networker" command via 
>email to listserv AT listserv.temple DOT edu or visit the list's Web site at 
>http://listserv.temple.edu/archives/networker.html where you can also 
>view and post messages to the list. Questions regarding this list 
>should be sent to stan AT temple DOT edu 
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via
email to listserv AT listserv.temple DOT edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can also
view and post messages to the list. Questions regarding this list should
be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

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
wit 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