Get Solutions Containing Web Resource

Snipit to determine which solutions contain a web resource.

SELECT TOP 1000 
 S.FriendlyName, 
 s.UniqueName, 
 WR.DisplayName, 
 WR.Name     
  FROM [Default_MSCRM].[dbo].[SolutionComponentBase] SC
  LEFT JOIN Default_MSCRM.dbo.SolutionBase S ON S.SolutionId = SC.SolutionId
  INNER JOIN Default_MSCRM.dbo.WebResourceBase WR ON WR.WebResourceId = SC.ObjectId
  WHERE WR.Name LIKE '%classeventscoresheet.htm%'