Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

TSM Server Script

Hi

i want to know if i can add to this script start date and end date

like between 12/08/2013 to 12/08/2014 for tsm server version 6 & 7

 TOTALDATA - Desc="Display amount of data stored on TSM (auditocc)"

SELECT CAST(FLOAT(SUM(backup_mb))/1024 as DEC(8,1)) as BACKUP_GB, CAST(FLOAT(SUM(backup_copy_mb))/1024 as DEC(8,1)) as BACKUP_COPY_GB, CAST(FLOAT(SUM(archive_mb))/1024 as DEC(8,1)) as ARCHIVE_GB, CAST(FLOAT(SUM(archive_copy_mb))/1024 as DEC(8,1)) as ARCHIVE_COPY_GB, CAST(FLOAT(SUM(total_mb))/1024 as DEC(8,1)) as TOTAL_GB from auditocc
0
David Regev
Asked:
David Regev
1 Solution
 
woolmilkporcCommented:
The AUDITOCC table does not contain a history.
That's because it is recreated at each run of "AUDIT LICENSES".

So it doesn't contain any timestamp column to run a "where" clause against.

The "OCCUPANCY" table which keeps continuous storage occupancy records
doesn't contain timestamps either.

In fact, there is no way to query how the occupancy of TSM storage looked in the past
 if you don't keep continuous records yourself (e. g. by running a daily script to store daily values) .
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now