Alias's and documents

Birger_Jacobsen_(danskadmin_-_(deleted))

Could any one help me with a report that return the ObjId of an Alias and the related document objid and evt. the parentIdThanks

Steve_McDonough

Try:Select D1.DataID "Alias Object ID", D1.Name "Alias Name", D1.OriginDataID "Original Object ID", D2.NAME "Original Object Name", D2.ParentID "Original Folder ID", D3.Name "Original Folder Name" FROM DTree D1, DTree D2, DTree D3 WHERE D1.SubType = 1 AND D2.DataID = D1.OriginDataID AND D3.DataID = D2.ParentID ORDER BY D1.DataIDThe format of the report is AutoLiveReport. You can add or subtract any of the fields displayed