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

Backup Completion for Specific Node

Hiten

ADSM.ORG Member
#1
Hi,

I have TSM version 6.4.3 and using TSM Operational Reporting - Version 5, Release 5, Level 7.0 to get daily backup reports for 24hrs. We got new requirement for compliance team to provide separate report for each node. How can i get the same? I tried to frame select statements but not make it. Can some one help?

Currently total 10 nodes report coming in single html format which i want separate for each node.
 

marclant

ADSM.ORG Moderator
#2
You should upgrade to a current release and use the Operation Center to create you reports, it will be much easier to do. You can add any SQL query you want to reports in the Operation Center. You'd just need to create 10 reports and have where clause in each with `NODE_NAME='NODE'`.
 

Hiten

ADSM.ORG Member
#3
You should upgrade to a current release and use the Operation Center to create you reports, it will be much easier to do. You can add any SQL query you want to reports in the Operation Center. You'd just need to create 10 reports and have where clause in each with `NODE_NAME='NODE'`.
Thanks but i could not frame complete SQL query. can you pls update me?
 

Hiten

ADSM.ORG Member
#5
What's the query you are using today for your current report that shows all nodes?
We are using below script.
Select entity, substr(cast(min(start_time) as char(29)),1,10) as "start date" , substr(cast(min(start_time) as char(29)),12,8) as"start time", substr(cast(max(end_time) as char(29)),1,10) as "end date", substr(cast(max(end_time) as char(29)),12,8) as "end time", cast(bytes/1024/1024 as decimal(8,2)) as MB, successful from summary where activity='BACKUP' and start_time>=(current_timestamp - 30 hours) group by entity, successful, bytes
 

marclant

ADSM.ORG Moderator
#6
Ok, so you just need to add to your where clause:
SQL:
... where activity='BACKUP' and entity='NODENAME' and start_time ...
 

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

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

    Votes: 9 10.8%
  • Other (please comement)

    Votes: 7 8.4%

Forum statistics

Threads
31,400
Messages
133,753
Members
21,509
Latest member
seun
Top