• 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.

How to get this view

illllm

ADSM.ORG Member
#1
Hi Everyone,

I am trying to create a report that will display this:

Node Name | Amount to Backup | Last Backup Date | Last Backup Size | # Files Backed up | Number of Skipped Files

How do i query the TSM db for this ? I looked at Tobias.org and some of the SQL queries here but it does not give this information.

thanks,
 

Ches

ADSM.ORG Member
#2
The summary table should pretty much have the info you're after. Something like:
select entity as Node,examined as FileCount,end_time as last_backup,bytes/1024/1024/1024 as GB,affected as Files_backed_up,failed as Files_failed from summary where activity='BACKUP'
 

illllm

ADSM.ORG Member
#5
Is there a way to combine two node names together and show their totals ? I mean, For eg: SQL DBbackups show two jobs on the same date. I need to combine the jobs to show one node name with total of the two jobs.
 

Ches

ADSM.ORG Member
#7
Is there a way to combine two node names together and show their totals ? I mean, For eg: SQL DBbackups show two jobs on the same date. I need to combine the jobs to show one node name with total of the two jobs.
I finally got to a TSM server so can test. Something like this can give you the output from multiple backup activities in the last 24 hours, with the most recent end time if there are multiple activities:

Code:
select distinct(entity)as "Node name",sum(examined) as "Files examined",sum(affected) as "Files backed up",sum(failed) as "Files failed",sum(bytes/1024/1024/1024) as "GB backed up",max(end_time) as "Last backup end" from summary where activity='BACKUP' and end_time>=current_timestamp - 24 hours group by entity
illllm said:
so this query give me a list of names....how do i see what under each of those tables ?
Once you get the table name, you can query like this:
Code:
>select colname from syscat.columns where tabname='SUMMARY'
 

illllm

ADSM.ORG Member
#8
trying to learn this .... could you please help understand --this does not work:

SELECT distinct (Node_Name) as Node_Name, sum(bkbytes_to_replicate/1024/1024/1024) as GB_To_Replicate, sum(bkbytes_replicated/1024/1024/1024) as GB_Replicated from replicationview
 

Ches

ADSM.ORG Member
#9
I'm away from the server again, but give this a whirl:
SELECT Node_Name, sum(bkbytes_to_replicate/1024/1024/1024) as GB_To_Replicate, sum(bkbytes_replicated/1024/1024/1024) as GB_Replicated from replicationview group by node_name
 

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: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,469
Messages
134,129
Members
21,569
Latest member
srinathkodela
Top