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 nodes with no schedule?

Discussion in 'Command Line Administrator Client' started by cwilloug, May 25, 2011.

  1. cwilloug

    cwilloug ADSM.ORG Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    389
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    It must be a Monday morning... does anyone have a way to query all nodes and list node with no schedule associated with them?

    Thanks
     
  2.  
  3. unixandtsm

    unixandtsm ADSM.ORG Member

    Joined:
    Feb 9, 2011
    Messages:
    307
    Likes Received:
    0
    Hi,
    The following query will do the trick.

    select node_name from nodes where node_name NOT IN (select node_name from associations)
     
  4. cwilloug

    cwilloug ADSM.ORG Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    389
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    Thanks! That worked.
     
: schedule

Share This Page