this is what i tried:
select t.name, c.name, concat('select ''', t.name, ''' as tb, ''', c.name, ''' as col, cast(', c.name , ' as nvarchar(200)) as txt from ', t.name ,' where ', c.name ,' like ''%Person%'' union') from
inner join InformaticaModelRepositoryV101.sys.tables t
on c.object_id = t.object_id
and system_type_id IN (99,175,239,231,35,167,241)
order by t.name
then paste the last column in SSMS, remote the last UNION. I guess the hard part is when you do find a reference, what object is it in.
Please be aware that it is not supported and recommended to run sql queries against IDQ Model repository service database tables.
You can refer to database view reference to see if there are any external views (MRX) that can help provide the information you are looking for: Preface
If there are further questions, please open a support case with Informatica support.