You can generate the SQL to look for the index you have in each of your databases by using something like this:
select 'select *
from ' + name + '.sys.indexes i
where i.name = ''typeYourIndexNameHere'''
from master.sys.databases
where name not in ('master', 'tempdb', 'model', 'msdb')
Might save you a little bit of time.