Results 1 to 10 of 10
  1. #1
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default TSM - Help SELECT

    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. #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

    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.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    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

  4. #4
    Senior Member domino's Avatar
    Join Date
    Nov 2005
    Location
    Germany
    Posts
    702
    Thanks
    1
    Thanked 24 Times in 22 Posts

    Default

    Quote Originally Posted by girreis View Post
    ...what the AUDIT LICENSE command does? ...
    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.
    If Microsoft is the answer, I want my problem back!

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

    Default

    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
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  6. #6
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    This command causes AUDIT LICENSES stop the TSM Server?

    Thanks,
    Ramon

  7. #7
    Senior Member domino's Avatar
    Join Date
    Nov 2005
    Location
    Germany
    Posts
    702
    Thanks
    1
    Thanked 24 Times in 22 Posts

    Default

    Quote Originally Posted by girreis View Post
    This command causes AUDIT LICENSES stop the TSM Server?
    No .......
    If Microsoft is the answer, I want my problem back!

  8. #8
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    This command will be in txt file or how can I do?

  9. #9
    Moderator Harry_Redl's Avatar
    Join Date
    Dec 2003
    Location
    Czech Republic
    Posts
    2,220
    Thanks
    3
    Thanked 100 Times in 99 Posts

    Default

    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

  10. #10
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    Thanks for the help.

    Ramon

Similar Threads

  1. Select in TSM 6.1
    By staham in forum TSM Server
    Replies: 1
    Last Post: 02-03-2011, 05:34 AM
  2. Select command for TSM Mgmtclass
    By sunny19 in forum TSM Server
    Replies: 5
    Last Post: 11-22-2010, 02:08 PM
  3. Using select subqueries TSM 5.x
    By yquirion in forum TSM Operation
    Replies: 1
    Last Post: 10-26-2010, 05:33 PM
  4. Need some help converting select to TSM 6.1
    By MrStormy in forum Scripting
    Replies: 0
    Last Post: 11-06-2009, 12:47 PM
  5. Performance of SELECT on TSM-Database
    By karin in forum Performance Tuning
    Replies: 1
    Last Post: 08-28-2003, 04:04 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
  •