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 - Help SELECT

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

  1. girreis

    girreis ADSM.ORG Member

    Joined:
    Feb 11, 2011
    Messages:
    118
    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 ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    45
    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 ADSM.ORG Member

    Joined:
    Feb 11, 2011
    Messages:
    118
    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 ADSM.ORG Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    720
    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 ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    45
    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 ADSM.ORG Member

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

    Thanks,
    Ramon
     
  8. domino

    domino ADSM.ORG Senior Member

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

    girreis ADSM.ORG Member

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

    Harry_Redl Moderator ADSM.ORG Moderator

    Joined:
    Dec 29, 2003
    Messages:
    2,271
    Likes Received:
    136
    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 ADSM.ORG Member

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

    Ramon
     

Share This Page