Results 1 to 2 of 2
  1. #1
    Newcomer
    Join Date
    Aug 2006
    Posts
    450
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Default Need a script to count NON dissociated windows clients

    Hi,

    Does anyone have a script or know a command to count the number of windows nodes/clients left on a server that ARE NOT DISSOCIATED? we have dissociated a number of nodes and I would like to count the remaining clients left. However I don't want to include the dissociated clients that are still left on the TSM Server


    Thanks for any help!

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,858
    Thanks
    4
    Thanked 228 Times in 223 Posts

    Default

    Try this from (as a starting point) http://thobias.org/tsm/sql/index.html#toc24:

    SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)
    Ed

  3. The Following User Says Thank You to moon-buddy For This Useful Post:

    tsmhelum (07-30-2012)

Similar Threads

  1. Script to count the maxscratch of a pool
    By khawts in forum Scripting
    Replies: 4
    Last Post: 08-10-2013, 03:17 PM
  2. Need a script to show Windows 200 clients
    By tsmhelum in forum Scripting
    Replies: 3
    Last Post: 09-26-2011, 10:31 AM
  3. Script for installing clients in Windows
    By luisvidal in forum Scripting
    Replies: 3
    Last Post: 05-12-2010, 09:19 AM
  4. Script to count the node version
    By khawts in forum Scripting
    Replies: 4
    Last Post: 03-06-2009, 10:49 AM
  5. Script to count the number for tapes
    By khawts in forum Scripting
    Replies: 3
    Last Post: 06-15-2007, 12:39 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
  •