Storage Management

Expand all | Collapse all

how to get specific months or day backup status on SPP

  • 1.  how to get specific months or day backup status on SPP

    Posted Wed December 18, 2019 10:47 AM
    Hi All,

    I am trying to figure out is there any way to get specific day or month backup status report on SPP.


    ------------------------------
    Thanks
    Prem

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


  • 2.  RE: how to get specific months or day backup status on SPP

    Posted Thu December 19, 2019 10:27 AM
    Following  will work for a specific day. Note the times 16:30:00 to 16:29:59 are the ones that work for my setup.


    Select count(message) as "SUCCESSFUL CLIENT BACKUPS!!" from actlog where message like 'ANR2507I%' and (date_time between TIMESTAMP ('2019-06-22 16:30:00') and TIMESTAMP ('2019-06-23 16:29:59')) and message not like '%Administrator%'

    Select count(message) as "FAILED CLIENT BACKUPS!!" from actlog where message like 'ANR2579E%' and (date_time between TIMESTAMP ('2019-06-22 16:30:00') and TIMESTAMP ('2019-06-23 16:29:59')) and message not like '%Administrator%'

    Select count(message) as "MISSED CLIENT BACKUPS!!" from actlog where message like 'ANR2578%' and (date_time between TIMESTAMP ('2019-06-22 16:30:00') and TIMESTAMP ('2019-06-23 16:29:59')) and message not like '%Administrator%'

    SELECT count(node_name) as "TOTAL SCHEDULED CLIENT BACKUPS!!" FROM EVENTS WHERE (SCHEDULED_START between TIMESTAMP ('2019-06-22 16:30:00') and TIMESTAMP ('2019-06-23 16:29:59')) and node_name is not null

    ---------------------------------------------------------------------
    Following is a daily report that can be put into the Operations center reports. Or put into a script. The times used in the report are specific to my setup. 
    SUCCESSFUL CLIENT BACKUPS
    Select count(message) as "SUCCESSFUL CLIENT BACKUPS!!" from actlog where message like 'ANR2507I%' and date_time between (current DATE - 1 days) CONCAT ' 16:00:00' AND (current DATE - 0 days) CONCAT ' 08:00:00' and message not like '%Administrator%'

    FAILED CLIENT BACKUPS
    Select count(message) as "FAILED CLIENT BACKUPS!!" from actlog where message like 'ANR2579E%' and date_time between (current DATE - 1 days) CONCAT ' 16:00:00' AND (current DATE - 0 days) CONCAT ' 08:00:00' and message not like '%Administrator%'

    FAILED CLIENT BACKUPS DISTINCT
    select distinct count(substr(char(message),uno+9,dos-uno-9)) from (Select message, LOCATE_IN_STRING(MESSAGE,'Schedule ') as uno,LOCATE_IN_STRING(MESSAGE,' in domain') as dos from actlog where message like 'ANR2579E%' and date_time between (current DATE - 1 days) CONCAT ' 16:00:00' AND (current DATE - 0 days) CONCAT ' 08:00:00' and message not like '%Administrator%')

    MISSED CLIENT BACKUPS
    Select count(message) as "MISSED CLIENT BACKUPS!!" from actlog where message like 'ANR2578%' and date_time between (current DATE - 1 days) CONCAT ' 16:00:00' AND (current DATE - 0 days) CONCAT ' 08:00:00' and message not like 'Administrator'

    STILL RUNNING CLIENT BACKUPS COUNT
    select count(client_name) as "STILL RUNNING CLIENT BACKUPS!!" from (select DISTINCT t1.client_name, t2.node_name, session_type from sessions t1 left join nodes t2 on t1.client_name=t2.node_name where t1.client_name=t2.node_name and session_type='Node')

    TOTAL SCHEDULED CLIENT BACKUPS
    SELECT COUNT(SCHEDULE_NAME) as "TOTAL SCHEDULED CLIENT BACKUPS!!" FROM EVENTS WHERE (SCHEDULED_START between (current DATE - 1 days) CONCAT ' 08:00:01' AND (current DATE - 0 days) CONCAT ' 08:00:00') and node_name is not null

    STILL RUNNING CLIENT BACKUPS LIST
    select DISTINCT t1.client_name, t2.node_name from sessions t1 left join nodes t2 on t1.client_name=t2.node_name where t1.client_name=t2.node_name and t1.SESSION_TYPE='Node'

    MISSED BACKUP SCHEDULES
    select substring( message, 19, LOCATE_IN_STRING(message, ' in domain')-19) as node_n from (Select message from actlog where message like 'ANR2578%' and date_time between (current DATE - 1 days) CONCAT ' 16:00:00' AND (current DATE - 0 days) CONCAT ' 08:00:00' and message not like 'Administrator') order by node_n

    ------------------------------
    Lynn Hall
    ITS 4
    OCIO State of Iowa
    Des Moines IA
    515 669 4325
    ------------------------------



  • 3.  RE: how to get specific months or day backup status on SPP

    Posted Thu December 19, 2019 12:38 PM
    Hi,

    I think you misunderstood me I am talking about spectrum protect plus which is vm backup solution and you have shared me select for TSM.

    Thanks
    Prem 





  • 4.  RE: how to get specific months or day backup status on SPP

    Posted Thu December 19, 2019 06:21 PM
    Edited by Jochen Meixner Thu December 19, 2019 06:21 PM
      |   view attached
    Hi Prem,
    I am not completely sure what you are looking for...

    I have a SPP with German language setting and cannot switch it to English right now, so I will try to translate the menus, so the menu entries are probably not exactly named as I translate them...

    On the main menu on the left side you have an entry "Reports and Protocols" , select "Reports" and you seee in the main window 4 categories of reports.
    One of them should be something like "VM Backup Protocol" or "VM Backup Report". Select this report and in the options further down you can select the number of days you want to be included in your report. Click on the Button "Run", "Generate" or what ever it is named and you get the report at the bottom of the page.
    This is the reports which could be the one you are looking for I think....

    Then the report looks like the one in the attached picture. It's in German but I think you get the important infos....

    Best regards,
    Jochen

    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    CONET Services GmbH
    Duesseldorf, Germany
    ------------------------------



  • 5.  RE: how to get specific months or day backup status on SPP

    Posted Thu December 19, 2019 09:57 PM
    Hi Jochen,

    Yes you are right but you can fetch report for last 1-2 day etc. But if I wanted to pull report for only October month I can't I need to select last days which falls under my requirement but I don't need any report for November and December month why I will fetch and if I wanted to fetch only October 30 report in this scenario I can't. Hope you understand my request now.

    Thanks 
    Prem 





  • 6.  RE: how to get specific months or day backup status on SPP

    Posted Fri December 20, 2019 10:34 AM
      |   view attached
    Hi Prem,
    ok, I see your problem....

    I don't see a solution for this in the moment. You can send a feature request to IBM.
    Good old actlog in SP with the SQL interface gives you all information you need...

    But I think I found a workaround.
    Log in via SSH as root to the SPP appliance and switch to the directory /opt/IBM/SPP/logs
    In this directory are sub-directories for every day backups were made. And in these directories are log files for each processed VM with a n successful backup. You finde the VM name at the beginning of each log file.

    You can't get all VMs with unsuccessful backup, too. For these VMs are no log files present. Perhaps these logs are at another location...

    I hope this helps, it is not the ideal solution, but better than nothing....

    Best regards,
    Jochen

    ------------------------------
    Jochen Meixner
    Principal Consultant Storage & Backup Solutions
    CONET Services GmbH
    Duesseldorf, Germany
    ------------------------------