Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Jun 2008
    Location
    Georgia
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default List all schedules for all nodes

    We have been creating some new schedules and moving nodes from existing schedules to the new schedules. Because there is no move node from scheduleA to scheduleB, you have to do an add and deleted. So now I need to make sure we don't have a node on multiple schedules.

    I know I can get a list of all the nodes associated with each schedule via "q association" and then look at all the schedules for a duplicate nodes. But there are about 15 schedules and over 300 nodes. And I can see if a given node is associated with multiple schedules via

    select node_name,schedule_name from associations where node_name='ABC'

    But this means I would have to run the command over 300 times.

    What I want is to get a list of all the schedules for all the nodes.

    I have tried something like:

    select node_name,schedule_name from associations where node_name is (select node_name from node)

    But I cannot seem to get the correct syntax. I want the output to be something like:

    node_name schedule_name
    ----------- --------------
    ABC SCHED1
    DEF SCHED1
    DEF SCHED2
    GHI SCHED1

  2. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 25 Times in 24 Posts

    Default

    I must be missing something because the following select would easily show all nodes associated with a schedule and order them by the node_name then by schedule_name.

    select node_name, schedule_name from associations order by node_name, schedule_name
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Newcomer
    Join Date
    Jun 2008
    Location
    Georgia
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Chad:
    No, you are not missing anything, I am. The little I know about SQL is using something sombody else wrote and making minor changes.

    Thanks for the quick reply, that is exactly what I was looking for.

    I ran it and from the first page I found 2 nodes on multiple schedules and they were not even some we have been working with. They have probably been there for a while.

Similar Threads

  1. Need help viewing schedules with no associated nodes
    By eviemorgan in forum Scripting
    Replies: 4
    Last Post: 03-08-2012, 11:27 PM
  2. Two nodes or schedules on one server?
    By Udo in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 03-10-2010, 06:09 AM
  3. Replies: 3
    Last Post: 12-05-2007, 01:09 PM
  4. Client Nodes and Schedules
    By chalkd in forum TSM Reporting & Monitoring
    Replies: 1
    Last Post: 06-29-2007, 07:09 AM
  5. List nodes not in a schedule
    By cheffern in forum Scripting
    Replies: 5
    Last Post: 08-09-2006, 03:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •