Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Feb 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Want a command to find out all the nodes that have been failing or missing backups

    Want a command to find out all the nodes that have been failing or missing backups that have been failing or missing backups CONTINUOSULY for past 7 days.

    Not all nodes failed or missed. but nodees that have been CONTINUOSULY missing and failing for past 7 days.

    Thanks in Advance
    Rohit

  2. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    263
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Hi,

    This a sample, you can add a date statement too. Make sure your events table has data retention for 7 days.

    Code:
    select NODE_NAME,count(STATUS) from events where status<>'Completed' group by node_name having count(STATUS)>5
    Last edited by Trident; 08-31-2012 at 02:52 AM. Reason: spelling bug
    -= Trident =-

  3. #3
    Member gimlet's Avatar
    Join Date
    Apr 2008
    Location
    St. Louis, Missouri
    Posts
    153
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    Here's a query I use to see if any nodes have not backed up anything in the previous 24 hours:

    select nodes.node_name as "NO BACKUP" from nodes where not exists (select distinct entity from summary where (end_time
    between current_timestamp - 24 hours and current_timestamp) and (entity=nodes.node_name))

Similar Threads

  1. How to find missing tapes
    By rstockon in forum Tape / Media Library
    Replies: 10
    Last Post: 01-11-2012, 11:04 AM
  2. Replies: 1
    Last Post: 05-31-2011, 11:47 AM
  3. Find Nodes that are NOT scheduled
    By John22439 in forum Scripting
    Replies: 3
    Last Post: 01-31-2008, 10:15 AM
  4. Client nodes are missing under ISC
    By avinim8 in forum ISC -Integrated Solution Console
    Replies: 0
    Last Post: 06-07-2007, 12:59 PM
  5. command to find retention period of nodes
    By adsm04 in forum Administrative Client
    Replies: 2
    Last Post: 03-06-2007, 01:54 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •