Report if the Folder/Document has a shortcut linked to it

Jessica_Hixon

Is there a way to report the information listed on the “Reference” tab under Properties of a document or folder? This information shows if someone has created a shortcut somewhere else in the database.Thanks in advance for your help.

Appu_Nair

This is probably in the LR canned with livelink but it is rather simple.Assume you have an alias(shortcut) that points to some other dataid in livelink then the query to find if you know the alias id isselect origindataid from otcs10.livelink.dtree where dataid=4083You can expand that because all aliases have the same subtypeshow me all the original things of everything in my livelink that has aliases would beselect origindataid from otcs10.livelink.dtree where subtype=1Note if you have 2 million alias objects it will take that long so try reducing the scope using some good fiters.You can then filter the origindataid's on 144 to see how many of them are documents