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

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

  1. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    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 New 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 Senior Member

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

Share This Page