Try this, but you need to point this to ce90 database.
select a1.ObjName as FolderName, a2.ObjName as ProgramName
from aps_infoObjects2 a1 inner join aps_infoObjects2 a2 on a1.ObjectID = a2.ParentID
where a1.typeID = 1 and a1.ObjFlags = 0
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.