Forum Discussion

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

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.

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    8 years ago

    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

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    8 years ago
    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
      8 years ago

      Thanks for that.

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

      Thanks,

      AJ

      • RiaanBadenhorst's avatar
        RiaanBadenhorst
        Level 6
        8 years ago

        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