Solved

Backup status

Posted on 2010-09-16
9
678 Views
Last Modified: 2013-11-14
i need tsm sql query to display the backup status as below and need to group by platform

                          Winnt       HP-UX  SOLARIS

(for all possible status in event table )
       

Completed          

Missed

Failed

started

pending

restarted or severed        

0
Comment
Question by:ibmsddk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33701277
Hi,
try this, but please be aware that it could take a long time to complete (depending on the number of events/nodes), since the query has to contain an inner join.
select nodes.platform_name, events.node_name, events.status      -
           from nodes, events     -
   where events.node_name=nodes.node_name     -
         and events.status not like 'Future'       -
  group by nodes.platform_name, events.node_name, events.status     -
  order by nodes.platform_name, events.status, events.node_name  

Without specifying a beginning date only the current day's events are displayed. This is because the events table is built dynamically for items older than the current day.
To report about past events you should add an "events.scheduled_start" restriction containing an artificial beginning date to the "where" clause.
If all this is not what you expected please post a sample how you'd want the output to look like.
wmp
 
0
 

Author Comment

by:ibmsddk
ID: 33736918
format is this

                                 Completed        Missed       Failed  Severed ......possible staus in event table


Platform_name

Winnt

HP-UX

Solaris

...

ALL poosible palatform_name

     
0
 

Author Comment

by:ibmsddk
ID: 33736983
and its okay if it needs computed per 24 hours ..
i.e using scheduled_start between date in format " '2009-10-08 00:00:00' and '2009-10-09 00:00:00'"
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33737020
Did you run the query I gave you?
0
 

Author Comment

by:ibmsddk
ID: 33887373
No Solution obtained
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33887720
Doesn't my query do what you expected?
0
 

Author Comment

by:ibmsddk
ID: 33915797
i need the count in NOS as per status....
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33924139
Here you go.

select  -       count(events.node_name) "# of Nodes",  -       nodes.platform_name,  -       events.status  - from  -       events, nodes  -  where  -       events.node_name=nodes.node_name  -   group by  -       events.status, nodes.platform_name



0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 33928060
Here is the same for yesterday 00:00:00 to  23:59:59 - will take a lot longer because of the dynamic table construction:
select  -
       count(events.node_name) "# of Nodes",  -
       nodes.platform_name,  -
       events.status  -
 from  -
       events, nodes  -
  where  -
      ((scheduled_start >= '2010-01-01' -
   and   scheduled_start >= timestamp(current date - 1 day, '00:00:00')) -
   and  (scheduled_start >= '2010-01-01' -
   and   scheduled_start <= timestamp(current date - 1 day, '23:59:59'))) -
   and   events.node_name=nodes.node_name  -
     group by  -
         nodes.platform_name, events.status

Please don't be astonished - you actually need the additional date restrictions ("2010-01-01") to initiate the dynamic table construction!
wmp
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need Inexpensive 8TB  3.5 inch drives 14 117
SBS serve  2008 offsite backup 2 111
how to run a TSM script twice a day? 9 63
Windows Backup, Twice Daily 7 36
How to fix error ""Failed to validate the vCentre certificate. Either install or verify the certificate by using the vSphere Data Protection Configuration utility" when you are trying to connect to VDP instance from Vcenter.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question