Solved

TSM Server Script

Posted on 2014-10-01
1
245 Views
Last Modified: 2014-10-02
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
Comment
Question by:David Regev
1 Comment
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 40355473
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SBS serve  2008 offsite backup 2 54
Robocopy questions 45 124
My reclamation process on TSM is failing. 2 38
Recreate datastore 7 53
AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now