cancel
Showing results for 
Search instead for 
Did you mean: 

Week at a glance - can it show a month at a time?

StarSister
Level 4

OpsCenter Version 7.5.0.4 Report Templates>Backup>Status & Success Rate>Status> Week at a Glance:

Ideally I'd like a report which will allow me to show a dashboard to the server owners with the visual format of the 'week at a glance' report, which would show a rolling month on the one screen.

The only other way I can think to achieve this is to run several 'week at a glance' reports, but have the time frame differ for each - ie show 2 weeks back, then show current week. But, this would incur an admin overhead to create several reports to display on the dashboard. I understand the limitations of my version to only ever show me 28 days historically.

Is anyone aware of how I might achieve this, or another report which could accommodate me?

with thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions

Jim-90
Level 6

Is this for my monthly reporting.

Step 1  Generate a default report from Report Templates > Backup > Job Browser > Tabular Backup Report.  The only thing I change is the start and finish time.  Being one its huge and takes a while to generate.  Then I download it as CSV file.   Because of its size you have to make an adjust in OpsCenter config somewhere (its in the manual)

Step 2 Copy it to box that a bash shell - I use Linux, previously I used the Cygwin unix emulator on a windows desktop.

Step 3 Run the script to produce a summary.

#!/bin/bash
# Author : Jim McDonald
if [[ "$#" -ne "1" ]] ; then
echo "Requires an OpsCenter report in CSV format as the first and only parameter"
exit
fi
let ALL_BKUPS=$(cat $1 | grep  ',Backup,'  | wc -l )
let SUCCESSFUL_CNT=$(cat $1 | grep  ',Backup,' | grep 'Successful,' | wc -l )
let FAILED=ALL_BKUPS-SUCCESSFUL_CNT
printf "Total Backup Jobs        = %s\nSuccessful Backups Jobs = %s\nFailed Backup Jobs       = %s\n" $ALL_BKUPS  $SUCCESSFUL_CNT $FAILED
PERCENTAGE="$(echo "scale=3 ; ($SUCCESSFUL_CNT/$ALL_BKUPS)*100" | bc)"
printf "Success Rate             = %3.3f%%\n" $PERCENTAGE
SERVER_CNT=$(cat $1 | awk ' BEGIN {FS=","} { print $1 }' | sort -u | wc -l )
printf "Servers backed up        = %s\n" $SERVER_CNT

It will give you

Total Backup Jobs         =

Succesful Backup Jobs =

Failed Backup Jobs      =

Succes Rate               =

Servers Backed Up      =

Succes rate is based on individual backup jobs, server backed up is a count of all the servers backed up.  For those familiar with bash/ksh scripting it relatively simple to add more functionality to the script.  Grep for restore jobs, a simple piece of awk will give data sizes.  Extracting more information will be dependent upon your naming conventions for policies, schedules, server names etc.

Step 4 Distribute to those that care. 

Step 5 Store the CSV somewhere safe.  This is a useful report if you have a collection of them then can be a good source of information that can be mined for trends etc.

 

 

 

View solution in original post

7 REPLIES 7

BulletproofNZ
Not applicable

I am wantingto do this exact same thing.

I have a client that would like to have the "week at a glance" report for the entire month to archive as part of his tracking of SLA's

V4
Level 6
Partner Accredited

i suspect analytics might help,  As we can customize it.. But it requires alot of patience to try multiple parameters or if you can do sql query to get same GUi reports (customization in report requires analytics license)

 

Try with eval if it helps (sync with symantec represantative for eval)

 

StarSister
Level 4

Thanks for your response. I was hoping not to go down the analytics route - as it would meaning purchasing many many licenses. If I put in an EVAL code, then see how amazing it is.......I believe it's too costly and I have a lot of clients on the domain.

 

I don't suppose you are aware of how to view the partially backed up files from the same report?

 

I am essentially looking for a way that the server owners in question can view their own backups and see which files have been paritally successful - without having to create separate reports for each server???

 

 

V4
Level 6
Partner Accredited

To be frank OpsCenter has kept most common required features LICENSED. i.e. requires analytics

following are some examples

Need media ID besides regular tabular report (Very important and generous requirement)

Partial backup details

Above both requires customizing reports which indirectly requires you to pay for analytics.

i'm aware of how to configure those reports that's why highlighted Analytics as recommendation to fulfill requirement

 

 

inn_kam
Level 6
Partner Accredited

RonCaplinger
Level 6

There is no way to show the entire month in one report, but there is a new option that I had not seen before, Week Information, that lets you define *which* week you want to include (This Week, Last Week, 2 Weeks Ago, etc.), and you could create 4 individual reports to display the type of data you are looking for.

I am using OpsCenter Analytics 7.5.0.5.  I don't know when this option was added, I never found this report format very useful.

Jim-90
Level 6

Is this for my monthly reporting.

Step 1  Generate a default report from Report Templates > Backup > Job Browser > Tabular Backup Report.  The only thing I change is the start and finish time.  Being one its huge and takes a while to generate.  Then I download it as CSV file.   Because of its size you have to make an adjust in OpsCenter config somewhere (its in the manual)

Step 2 Copy it to box that a bash shell - I use Linux, previously I used the Cygwin unix emulator on a windows desktop.

Step 3 Run the script to produce a summary.

#!/bin/bash
# Author : Jim McDonald
if [[ "$#" -ne "1" ]] ; then
echo "Requires an OpsCenter report in CSV format as the first and only parameter"
exit
fi
let ALL_BKUPS=$(cat $1 | grep  ',Backup,'  | wc -l )
let SUCCESSFUL_CNT=$(cat $1 | grep  ',Backup,' | grep 'Successful,' | wc -l )
let FAILED=ALL_BKUPS-SUCCESSFUL_CNT
printf "Total Backup Jobs        = %s\nSuccessful Backups Jobs = %s\nFailed Backup Jobs       = %s\n" $ALL_BKUPS  $SUCCESSFUL_CNT $FAILED
PERCENTAGE="$(echo "scale=3 ; ($SUCCESSFUL_CNT/$ALL_BKUPS)*100" | bc)"
printf "Success Rate             = %3.3f%%\n" $PERCENTAGE
SERVER_CNT=$(cat $1 | awk ' BEGIN {FS=","} { print $1 }' | sort -u | wc -l )
printf "Servers backed up        = %s\n" $SERVER_CNT

It will give you

Total Backup Jobs         =

Succesful Backup Jobs =

Failed Backup Jobs      =

Succes Rate               =

Servers Backed Up      =

Succes rate is based on individual backup jobs, server backed up is a count of all the servers backed up.  For those familiar with bash/ksh scripting it relatively simple to add more functionality to the script.  Grep for restore jobs, a simple piece of awk will give data sizes.  Extracting more information will be dependent upon your naming conventions for policies, schedules, server names etc.

Step 4 Distribute to those that care. 

Step 5 Store the CSV somewhere safe.  This is a useful report if you have a collection of them then can be a good source of information that can be mined for trends etc.