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.

TSM client script (or command)

Discussion in 'Scripting' started by tsmhelum, Jul 6, 2012.

  1. tsmhelum

    tsmhelum Active Newcomer

    Joined:
    Aug 24, 2006
    Messages:
    450
    Likes Received:
    0
    Hi


    Does anyone have a script or command that will display only windows clients, their os version (i.e. windows 2000, 2003 etc) and whether its 64bit or 32?


    Thanks


    TSM version 6.2.2
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,535
    Likes Received:
    299
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Not pretty but here is a startng point:

    SELECT node_name, platform_name, domain_name, CHAR(client_version)||'.'||CHAR(client_release)||'.'||CHAR(client_level)||'-'||CHAR(client_sublevel) as "TSM Client Version" FROM nodes where platform_name='WinNT'
     
    tsmhelum likes this.
  4. tsmhelum

    tsmhelum Active Newcomer

    Joined:
    Aug 24, 2006
    Messages:
    450
    Likes Received:
    0
    Ed thanks, I appreciate it the script helps a lot.
     

Share This Page