Extract to network location

[Mike_Kroner1]

Which table has the export locations for the workflow action "export to network location"? 

[Mike_Kroner1 · Accepted solution]

select A.ACTIONNUM, A.ACTIONNAME, L.LIFECYCLENAME,
rtrim(P.PROPERTYVALUE)
from ACTION A, ACTIONPROPS P, LIFECYCLE L
where A.ACTIONNUM = P.ACTIONNUM and A.SCOPE = L.LCNUM
and P.PROPERTYNAME = 'DefaultDirectory'
order by L.LIFECYCLENAME