TSM - Help SELECT

girreis

ADSM.ORG Member
Joined
Feb 11, 2011
Messages
119
Reaction score
1
Points
0
PREDATAR Control23

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
 
PREDATAR Control23

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.
 
PREDATAR Control23

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
 
PREDATAR Control23

...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.
 
PREDATAR Control23

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
 
PREDATAR Control23

This command causes AUDIT LICENSES stop the TSM Server?

Thanks,
Ramon
 
PREDATAR Control23

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

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
 
Top