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: ADSM-L AT VM.MARIST DOT EDU
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