TSM - Help SELECT

[girreis]

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

[chad_small]

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.

[girreis]

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

[domino]

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

[chad_small]

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

[girreis]

This command causes AUDIT LICENSES stop the TSM Server?

Thanks,
Ramon

[domino]

This command causes AUDIT LICENSES stop the TSM Server?

No .......

[girreis]

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

[Harry_Redl]

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

[girreis]

Thanks for the help.

Ramon