06-14-2017 05:44 AM
Is it possible, via Ops Center or Ops Center Analytics, to determine the amount of storage used on a 5230 appliance by either policy or preferably client ?
If it is not possible (due to de-dup rates etc.) then is it possible to generate the same report ignoring the fact that this is being written to a de-dup appliance and list the number and sizes of images present for a policy / client ?
Thanks,
AJ.
Solved! Go to Solution.
06-14-2017 11:08 AM
Try this (off the top of my head). it will show the results for the past day. Substitute "hour" with "day" if you want to increase the range (and adjust "24" accordingly)
select
sum (domain_JobArchive.bytesWritten) as "Bytes Written",
sum (domain_JobArchive.preSISSize) as 'Protected Size',
domain_JobArchive.clientName as "Client Name",
from domain_JobArchive,
where DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24
GROUP BY "Client Name" ORDER BY "Bytes Written" DESC
06-14-2017 06:17 AM
06-14-2017 08:26 AM
Thanks for that.
Not being a SQL guru, are there any SQL scripts out there to achieve this ?
Thanks,
AJ
06-14-2017 11:08 AM
Try this (off the top of my head). it will show the results for the past day. Substitute "hour" with "day" if you want to increase the range (and adjust "24" accordingly)
select
sum (domain_JobArchive.bytesWritten) as "Bytes Written",
sum (domain_JobArchive.preSISSize) as 'Protected Size',
domain_JobArchive.clientName as "Client Name",
from domain_JobArchive,
where DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24
GROUP BY "Client Name" ORDER BY "Bytes Written" DESC
06-15-2017 02:51 AM
Really appreciate this - but one glitch.....
Syntax error near 'from' on line 5
AJ
06-19-2017 11:45 PM
Sorry for the late reply...
Need to remove the comma "," from the line above "from blah blah"
06-20-2017 03:14 AM
Excellent - many thanks.
AJ