Identifying shortscuts in BI platform CMS system database

[former_member596929]

Hi,
how do I have to build a query based on BI platform CMS system database universe to get a list of all shortcuts including folder path of a defined object (hyperlink, lumx, webi)?

Thanks in advance
Christoph

[rajdeep_marathe]

SELECT si_id, si_name, SI_HYPERLINK_STRING FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'hyperlink'

SELECT si_id, si_name, si_files FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'webi'

SELECT si_id, si_name, si_files FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'lumx'

check if above helps !!

Regards,
Rajdeep