OK, let's face it... most scheduled events will be incremental
     backups.  The whole purpose here is to ensure you have daily copies of
     all files on all clients. (am I not right ?)

     Try this...

     select node_name,filespace_name,cast((backup_end) as varchar(10)) as
     "Date" from adsm.filespaces where
     (cast((current_timestamp-backup_end)day as decimal(18,0)>2)


     This will generate you a nice little report of each filespace (across
     the clients) that hasn't had an incremental successfully complete
     within the last two days.

     Hope this helps
     later,
           Dwight