Query to search Report Server

select * from dbo.ReportSchedule r

inner join catalog on r.reportid = itemid

inner join subscriptions s on r.subscriptionid = s.subscriptionid

where ExtensionSettings like '%vijay%'