Forum Discussion

SYM-AJ's avatar
SYM-AJ
Level 5
8 years ago

Appliance Storage Utilised by Client

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.

  • 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

6 Replies

  • 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's avatar
      SYM-AJ
      Level 5

      Thanks for that.

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

      Thanks,

      AJ

      • 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