Appliance Storage Utilised by Client

[SYM-AJ]

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.

[RiaanBadenhorst]

Its possible to show the pre and post figures for each client, its captured in the domain_jobarchive table. The post figure how is in terms of what was sent to the storage server and it probably doesn't represent what is stored in dedupe from as there would be shared components.

[SYM-AJ]

Thanks for that.

Not being a SQL guru, are there any SQL scripts out there to achieve this ?

Thanks,

AJ

[RiaanBadenhorst · Accepted solution]

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

[SYM-AJ]

Really appreciate this - but one glitch.....

Syntax error near 'from' on line 5

AJ

[RiaanBadenhorst]

Sorry for the late reply...

Need to remove the comma "," from the line above "from blah blah"

[SYM-AJ]

Excellent - many thanks.

AJ