07-04-2017 05:16 AM
Hi,
a customer wants to know the amount of backup data on a monthly base. I tried to use the report feature but I did not get any usable information.
Next idea was to use BECli and figure out the amount of data copied sucessfully to tape monthly. (only one full per client)
BEAgentServer | get-BEJobHistory -JobType duplicate -JobStatus succeeded -Storage "Robotic libary 0001" -FromStartTime 15.05.2017 -ToStartime 14.06.2017 | select -unique | sort name, totaldatasizebytes, starttime | export-csv -path c:\tmp\Datenmenge.csv -NoTypeInformation -encoding UTF8
It works without the "-Storage". I used "-Storage" @($storage[4]) the result of get-storage
Perhaps there is a better or different solution
Kind regards
Solved! Go to Solution.
08-24-2017 08:21 AM
My solution is:
Get-BEJobHistory -JobType duplicate -Storage (Get-BEStorage -Name "Tape*") -JobStatus succeeded -FromStartTime (get-date).AddDays(-30) -ToStartTime (get-date) | select -unique | sort name | select -Property name, storagename, starttime, totaldatasizebytes | export-csv -path c:\tmp\Data.csv -NoTypeInformation -encoding UTF8
The problem was that "Robotic libary 0001" is not recognized as a storage. (Tape001+Tape002 are)
The customer has two tapedrives in his libary and they are used once a month for outsourcing a successful full of every server.
I discarded to solve this with SQL queries.
07-10-2017 10:19 PM
You may create customer reports and choose following fields from Category "Job History Group"
Then add filter of start and end date like following (you may specify one month rage):
Then group by "server"
Then sort if by "Total Data Size"
You may also specify the "Graph Options"
Thanks and Regards,
Riyaj
07-13-2017 02:33 AM
Thank you for your answer, but this gives me every single backup, incremental or full for every server.
My "wish" is to get the amount of data from one full backup of all (~110) servers. The full backups are not on one day, they are spreaded over the week. So if I could filter something like "show me the amount of data from fulls of last week" would help. I cant´t find the filter for "backup type (full, diff, inc)" in the reports.
08-24-2017 08:21 AM
My solution is:
Get-BEJobHistory -JobType duplicate -Storage (Get-BEStorage -Name "Tape*") -JobStatus succeeded -FromStartTime (get-date).AddDays(-30) -ToStartTime (get-date) | select -unique | sort name | select -Property name, storagename, starttime, totaldatasizebytes | export-csv -path c:\tmp\Data.csv -NoTypeInformation -encoding UTF8
The problem was that "Robotic libary 0001" is not recognized as a storage. (Tape001+Tape002 are)
The customer has two tapedrives in his libary and they are used once a month for outsourcing a successful full of every server.
I discarded to solve this with SQL queries.
09-07-2017 05:35 AM - edited 09-07-2017 05:59 AM
09-07-2017 06:33 AM