David, I don't know what doesn't work for you for Exchange but for us that
select command returns equivalent results for both SQL and Exchange nodes.

The TDP command /adsmquerydb:* doesn't give you what you need? Does selecting
from the backups table make a difference (change backup_end to backup_date)?

Bob King     IBM GLobal Services
bobking AT us.ibm DOT com

From: "Tomblin, David" <David.Tomblin AT AVISTACORP DOT COM>@VM.MARIST.EDU>
      on 07/06/2000 12:50:44 PM
> I have been using "select node_name, filespace_name, backup_end from
> filespaces where node_name='XXXX-SQL'" in a script to confirm a usable
> backup on our MS SQL servers.  Works great on the SQL agent but not on MS
> Exchange agent.  Where does ADSM store the completion date and time on
> backups generated with ADSM Exchange agent?  Or is there an easier way to
> confirm a usable backups on multiple Exchange servers?
>
> David Tomblin