SQL scripts to get status of backups ran in the past 24 hours 'group by domain'

[TitusBandugula05011988]

Hello All,

I need a SQL command to get the below details in a similar view

NODE NAME | DOMAIN NAME | SCHEDULE NAME | BACKUP STATUS | START TIME | END TIME | ELAPSED TIME(optional)

 

[marclant]

Probably something close here: http://thobias.org/tsm/sql/

You may need to tweak the query to your specific requirements.