Unusual Reporting

[wamason]

Is there a way that I can tell the total amount of jobs that wre run\submitted in a given month. This would also include restores. Any one has any ideas. The regular reporting feature does not provide this information as far I can see.

 

[Stumpr]

Advanced Reporter option will do this for you but it is expensive.
A cheaper alternative is to export the Activity Monitor.
You can do it once a week and import the data into a spreadsheet.
Read "Managing the Jobs Database" in the admin guide.
It will tell you how to set the # days to keep jobs in the monitor.

Bob Stump
Incorrigible punster -- Do not incorrige

 

[wamason]

I am new to this environment. How do I know if I already have Advanced Reporter?

 

[sgoldsmith]

run bpps -a at the bottom of the Report you will see ARO process if its running.
Also the Advanced Report application is installed by Default in /opt/SUNWnbaro.
Also you can look in /etc/rc3.d for S90nbaro; this is the startup/shutdown script for Advanced Reporter.
Finally, point a browser to your master server with the following address:

http://master_server:8885/nbar.html

This is the default home page for Advanced Report.
If none of these work... then you haven't got advanced reporter installed.

Simon Goldsmith
Storage Engineer

 

[PGPhantom]

I have a "Daily Report" script that is run. From there, the results are imported into an Oracle Database and I run reports against that database so I can easily tell you how many jobs etc throughout a number of years.

#!/bin/ksh
#
#
###############################################################################
#
# Name: DailyReport.ksh
# Purpose: This script reports on NEtBackup Activites
# Created by: Steve Staves
# Date Created: January 14th, 2001
# Modified: March 10th, 2004 by Steve Staves
# Modification: Tracking changes to policies
#
###############################################################################
#
# Set up variables

OUTTEMP=d:/veritas/backupresults/temp.txt
OUTF=d:/veritas/backupresults/dailyreport.txt
POLICY=d:/veritas/backupresults/Policy_Changes.txt
OUTF2=d:/veritas/backupresults/policies_today.txt
OUTF3=d:/veritas/backupresults/policies_yesterday.txt
SS=d:/veritas/backupresults/detailed.txt
SR=//report_server/reports/veritas/hdailydetailed.txt
SUMMARY=//sherlock/reports/veritas/hdailysummary.txt
RES=d:/veritas/backupresults
ADMIN=d:/veritas/netbackup/bin/admincmd

#################################################################
#
# Initialize Log File

if [ -f $OUTF ];then
rm $OUTF
fi

if [ -f $OUTF3 ];then
rm $OUTF3
fi

#################################################################
#
# Main Body of Script
$ADMIN/bpdbjobs -report -all_columns > $SS
$ADMIN/bpdbjobs -report -all_columns > $SR
cp c:/srvapps/ActiveBatch/Scripts/printheader.txt $OUTF
echo "BACKUP JOB SUMMARY for `date`" >> $OUTF
echo "================================================== " >> $OUTF
echo " " >> $OUTF
$ADMIN/bpdbjobs -summary -L >> $OUTF
$ADMIN/bpdbjobs -summary > $SUMMARY
echo " " >> $OUTF
echo "BACKUP JOB STATUS for `date`" >> $OUTF
echo "================================================== " >> $OUTF
echo " " >> $OUTF
$ADMIN/bpdbjobs.exe -report > $OUTTEMP
cat $OUTTEMP | sort -r -k 4,5 >> $OUTF
echo " " >> $OUTF

cp $OUTF2 $OUTF3
$ADMIN/bpcllist > $OUTF2
echo " Policy Change Report for `date`" > $POLICY
echo "-------------------------------------------------------------------------- " >> $POLICY
echo "" >> $POLICY
echo " " >> $POLICY
echo "========================================================================== " >> $POLICY
echo " If anything appears below this line, it needs to " >> $POLICY
echo " be validated as there are policies missing or " >> $POLICY
echo " added to the list since yesterday. Send a " >> $POLICY
echo " message to the serverteam asking for verification " >> $POLICY
echo "========================================================================== " >> $POLICY
echo " " >> $POLICY
diff $OUTF2 $OUTF3 >> $POLICY

There are a number of "Outputs" as we do different things with each. You can modify this as you see fit. The last section is done so that we can compare the policy list from one day to the next so that we know if a policy has been deleted or added to the list.

 

[wamason]

Thanks everyone. I am good to go.