Here's a quick and dirty method: SELECT DISTINCT(NODE_NAME),FILESPACE_TYPE FROM FILESPACES or select node_name,platform_name from nodes where platform_name like 'TDP%'
The first gets all "agent" backups, the second, only TDPSQL. Glen Churchfield -----Original Message----- From: Coats, Jack To: [EMAIL PROTECTED] Sent: 3/28/2003 11:16 AM Subject: License anomaly on TDP for Exchange I am using the TDP for M$Exchange. I have a license for 3, am using 3, but my audit license says I am using 4, and can't seem to do anything to get the usage count to go down. Any suggestions on how to get it updated to the correct count? Is there a SQL Query I can run to tell me what clients are defined as having this TDP associated with them? Win 2K server, TSM 4.2.3 TIA, ... Jack
