gistfile1.txt

select 
t.name
, i.name
, s.user_seeks
, s.user_scans
, s.user_updates
, s.user_lookups
, s.last_user_seek
, s.last_user_scan
, s.last_user_lookup
, s.last_user_update 
from 
sys.tables t
inner join sys.indexes i on (i.object_id = t.object_id)
inner join sys.dm_db_index_usage_stats s on (i.object_id = s.object_id and i.index_id = s.index_id and s.database_id = 7 /*trio*/)
where t.type = 'U'
order by t.name, i.index_id