Networker free reporting tool NSR_REPORTER

 

NSR Reporter is an excellent free Networker reporting tool developed by Thierry Faidherbe, you can download it from below link.

http://users.skynet.be/networker_reporter/index.html

You can see the full documentation of this tool on above link and also the author is very supportive, you will definitely get answer for your mails.

I am running this tool weekly basis and configured to send the tabular report in an excel sheet to the management, I will explain it below. I am using blat.exe here for sending the attachment.

1. Install NSR_REPORTER

2. Go to NRU500\data\servername\config folder and open the file smtp_daily_excel_report_by_user.txt

3. Add your servers in the file as below, I have arranged my clients based on roles.

You can add on below format

servername1;outputfilename1

servername2;outputfilename2

So it will create report for my servers on separate excel sheets based on outputfilename

For Example:-

###DB Servers -–> output file name will be as nsr_reporter_servername_status_for_DBServers.xls###
sqlsrev1;DBServers
sqlserv2;DBServers
oraclesrv1:DBServers

### File server--> output file name will be nsr_reporter_servername_status_for_FileServers.xls###
Fileserv1;FileServers
FileServ2;FileServers

### Web Servers-->output file name will be nsr_reporter_servername__status_for_WebServers.xls ###
Web1;WebServers
Web2;WebServers

4. Run the reporting tool

NSR_REPORTER_5.0.exe -s bkpserv -q "1 week ago" -D MM/DD/YYYY -graph -nodns –noicmp

5.After it completed successfully  you can see the report file under C:\NRU500\data\servername\export folder

here it’s the content of my file nsr_reporter_servername__status_for_WebServers.xls

It will have client summary tab and detailed tab.

6.Now download and install blat.exe

blat -install <smart hostname>

Create a .bat file to send the mail as below format

blat.exe -to user1@company.com, user2@company.com -subject "Weekly Backup Report" -f fromaddress@company.com -attach C:\NRU500data\servername\export\nsr_reporter_servername__status_for_WebServers.xls

7. Schedule the nsr_reporter script and .bat file for sending mail using windows scheduler task according to your requirements.