1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

query Scheduler Results and No Scheduler association

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

  1. tomk

    tomk Newcomer

    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