SELECT	
		te.name
		,ft.LoginName
		,ft.Hostname
		,ft.ApplicationName
		,count(1) [BackupsMade]
		,sum(iif(TextData like 'backup log%',1,0)) [LogBackups]
		,sum(iif(TextData like 'backup database%',1,0)) [FullBackups]
FROM sys.traces st 
CROSS Apply	::fn_trace_gettable(left(st.path,len(st.path)-charindex('_',reverse(st.path)))+right(st.path,4), st.max_files) AS ft 
INNER JOIN sys.trace_events AS te ON ft.EventClass = te.trace_event_id 
WHERE 
	te.name LIKE '%Backup%'  
	and st.is_default=1 
	and st.status=1
	and ft.TextData not like '%verifyonly%'
group by
		te.name
		,ft.LoginName
		,ft.Hostname
		,ft.ApplicationName