https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

Find SSRS report designs that reference a specific stored procedure: SELECT CAST(CAST(content AS VARBINARY(MAX)) AS XML), Path, Name, CreationDate, ModifiedDate FROM dbo.Catalog where cast(CAST(CAST(content AS VARBINARY(MAX)) AS XML) as varchar(max)) like ‘%spRptPMWIP6%’