1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

query Scheduler Results and No Scheduler association

Discussion in 'Scripting' started by tomk, Oct 17, 2012.

  1. tomk

    tomk New Member

    Joined:
    Jul 5, 2011
    Messages:
    2
    Likes Received:
    0
    Occupation:
    Storage/Backup Adminsitrator
    Location:
    Vienna
    Hello,

    is it possible to create a script which reports for the last day the status and result from the scheduler and also lists all nodes which have no associations or otherwise combine the following two select statements:

    SELECT a.node_name, b.schedule_name, b.result, b.status FROM nodes a, events b WHERE a.node_name = b.node_name AND days(current_timestamp)-days(scheduled_start)=1
    SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

    Thanks
    tom
     
  2.  
: scheduler, script

Share This Page