Results 1 to 3 of 3
  1. #1
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default query nodes with no schedule?

    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. #2
    Member
    Join Date
    Feb 2011
    Posts
    306
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Default

    Hi,
    The following query will do the trick.

    select node_name from nodes where node_name NOT IN (select node_name from associations)

  3. #3
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default

    Thanks! That worked.

Similar Threads

  1. query filespace for nodes understanding
    By toddz2000 in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 03-02-2010, 10:17 AM
  2. A query that displays nodes and its associated volumes and last write.
    By mnagie in forum TSM Reporting & Monitoring
    Replies: 2
    Last Post: 08-09-2006, 02:07 PM
  3. Occupancy by all nodes in one query.
    By zeke in forum Performance Tuning
    Replies: 6
    Last Post: 07-07-2006, 03:06 AM
  4. How do I query Nodes that are not associated with a client schedule?
    By thekid241 in forum TSM Reporting & Monitoring
    Replies: 2
    Last Post: 05-23-2006, 01:30 PM
  5. IP query for all nodes connected
    By rsnyder in forum TSM Reporting & Monitoring
    Replies: 2
    Last Post: 03-10-2003, 05:31 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
  •