Data Protection Software

Expand all | Collapse all

Select to get backup success detail of few specific nodes

  • 1.  Select to get backup success detail of few specific nodes

    Posted Tue September 24, 2019 09:55 AM
    Hi All,

    I am looking for a select command to get a query of select to get the backup schedule success or failure email report through ops center on TSM version 8.1.5 for 10-15 specific clients, can anyone help on this.

    ------------------------------
    Prem Singh

    ------------------------------


  • 2.  RE: Select to get backup success detail of few specific nodes

    Posted Tue September 24, 2019 02:22 PM
    Hi Guys,

    Any immediate suggestions or advise pls.

    Thanks
    Prem 





  • 3.  RE: Select to get backup success detail of few specific nodes

    Posted Tue September 24, 2019 09:29 PM
    Anyone can advise anything to me urgently.

    Thanks
    Prem





  • 4.  RE: Select to get backup success detail of few specific nodes

    Posted Wed September 25, 2019 05:33 AM
    Hi Prem,

    From within the OC, go to the Reports section and then create a new report using custom SQL queries. You can then enter  multiple SQL queries to include in your report.

    If you wish to know backup events from the last 24 hours for specific nodes, you could use a query like:

    select * from events
    where scheduled_start>current_date-1 
    and node_name in ('node1', 'node2', 'node3')

    Regards
    Darren

    ------------------------------
    Darren Sanders
    Principal Consultant
    Celerity Ltd

    http://www.celerity-uk.com
    #ibmchampion storage
    ------------------------------



  • 5.  RE: Select to get backup success detail of few specific nodes

    Posted Wed September 25, 2019 08:59 AM
    Hi Darren,

    Thanks for the help you are a life saviour always, below statement worked for me .

    Thank you very much you are just amazing.


    select * from events where scheduled_start>current_timestamp-24 hours and node_name in ('A', 'B', 'C')

    the command you have provided below is the error while executing.

    ANR0162W Supplemental database diagnostic information:  -1:42816:-182 ([IBM][CLI Driver][DB2/AIX64] SQL0182N  An expression with a datetime value or a labeled duration is not valid.  SQLSTATE=42816

    --
    Regards
    Prem 





  • 6.  RE: Select to get backup success detail of few specific nodes

    Posted Wed September 25, 2019 09:09 AM
    Hi Prem,

    I copy and pasted your SQL query into dsmadmc session on an 8.1.6 and it worked fine for me.

    Protect: PROTECT01>select * from events where scheduled_start>current_timestamp-24 hours and node_name in ('A', 'B', 'C')
    ANR2034E SELECT: No match found using this criteria.

    Regards
    Darren

    ------------------------------
    Darren Sanders
    Technical Architect - Data Protection & Storage
    Celerity Ltd

    http://www.celerity-uk.com
    www.linkedin.com/in/darren-sanders-a8770a4
    #ibmchampion storage
    ------------------------------



  • 7.  RE: Select to get backup success detail of few specific nodes

    Posted Wed September 25, 2019 11:30 AM
    Thanks Darren,

    Yes it's working for me as well. but below syntax is not recognised while using your original command. this was not working however my purpose is solved now thank you so much for all your help and support.

    current_date-1  

    --
    Regards
    Prem 





  • 8.  RE: Select to get backup success detail of few specific nodes

    Posted Wed September 25, 2019 11:56 AM
    No problem at all. Pleased you got it working.



    ------------------------------
    Darren Sanders
    Technical Architect - Data Protection & Storage
    Celerity Ltd

    http://www.celerity-uk.com
    www.linkedin.com/in/darren-sanders-a8770a4
    #ibmchampion storage
    ------------------------------