• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Daily Tape usage query

jcrichton

ADSM.ORG Member
#21
Dude that file looks like it will be rather useful. Thanks. I am gonna endeavour to learn a scripting language for all this purposes and will post a script to what you want should I figure it out.
 

RaCol

ADSM.ORG Member
#24
Hi,

one possibility to analyse, which sessions causes how many mounts of media is to use the following SQL-query:

select session, count(*) "Number of mounts" from actlog where timestampdiff(8, char(current_timestamp-date_time))<=24 and message like '%mounted%' group by session order by 2

Another recommendation: if you want to include the SQL-query above in a report, which is automatically send to you together with other information like a detailed overview about your nightly usage of drives or a detailed view to the performance of your TSM-Server, you could use the freeware version of the tool "Power Administrator for TSM" (www.tsmpoweradmin.com). There is a "Operational Report" included, which gives you all this possibilities...

Regards, Ralf
 

girreis

ADSM.ORG Member
#25
friends,


Use the TSM Server 5.5 and also use Access 2003 to perform queries, but I'm not getting this result using SELECT:


select session, count (*) "Number of mounts" from where actlog TIMESTAMPDIFF (8, char (current_timestamp-date_time)) <= 24 and message like '%% mounted' group by session order by 2


Any help?


thankful,
Ramon
 

Hiten

ADSM.ORG Member
#28
You can also try below script if having Tiv0li Reporting ver. 5.4 and above.
SELECT volume_name,devclass_name,stgpool_name,pct_reclaim,pct_utilized,status,access FROM volumes order by pct_reclaim
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 16 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 52 61.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 10.7%
  • Other (please comement)

    Votes: 7 8.3%

Forum statistics

Threads
31,419
Messages
133,822
Members
21,533
Latest member
MACH
Top