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.

TSM - Help SELECT

Discussion in 'Command Line Administrator Client' started by girreis, Feb 18, 2011.

  1. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    113
    Likes Received:
    1
    Dear,

    We have the product TSM Server and Client 5.5, and some clients have signed up for TSM, but they no longer exist, how do I list these clients checking if there is any backup version stored (using select)?

    Thank you for your attention,
    Ramon
     
  2.  
  3. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    If they have any data stored you can run the following two commands (it's easier)

    AUDIT LICENSE
    Q AUDITOCC *

    This will show you the storage used by all nodes (As long as you have audit storage option turned on)
    If you want to check for a specific node then put that node name after the Q AUDITOCC.
     
  4. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    113
    Likes Received:
    1
    Chad_Small,

    Thanks for the help, but what the AUDIT LICENSE command does? It is a query? Only list?
    The command AUDITOCC Q *, although information MT will be great, the service may fall TSM?

    Thanks,
    Ramon
     
  5. domino

    domino Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    717
    Likes Received:
    32
    Occupation:
    System Engineer
    Location:
    Germany
    AUDIT LICENSES (Audit server storage usage)
    Use this command to audit the server storage used by client nodes and to audit the server licenses. The audit determines whether the current configuration is in compliance with the license terms.
     
  6. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    Q AUDITOCC * is safe and has never caused a problem. It is a built in query of the AUDITOCC table in the TSM DB. So you could also run

    SELECT * FROM AUDITOCC ORDER BY TOTAL_MB DESC
     
  7. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    113
    Likes Received:
    1
    This command causes AUDIT LICENSES stop the TSM Server?

    Thanks,
    Ramon
     
  8. domino

    domino Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    717
    Likes Received:
    32
    Occupation:
    System Engineer
    Location:
    Germany
    No .......
     
  9. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    113
    Likes Received:
    1
    This command will be in txt file or how can I do?
     
  10. Harry_Redl

    Harry_Redl Moderator

    Joined:
    Dec 29, 2003
    Messages:
    2,264
    Likes Received:
    135
    Occupation:
    IT Consultant
    Location:
    Czech Republic
    Hi,

    AUDIT LICENSE updates the AUDITOCC table in the DB. When using Q AUDITOCC you want to see the current data - that's why these commands are used in tandem - first update the table and then see the data. It is non-disruptive, TSM stays online.

    Harry
     
  11. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    113
    Likes Received:
    1
    Thanks for the help.

    Ramon
     

Share This Page