[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Backup status

Posted on 2010-09-16
9
Medium Priority
?
685 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
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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 1500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

608 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