Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
Identifying Folders in WorkSpaces
jsdeutch
We are looking to identify folders that are part of a WorkSpace. Currently we have one user account that creates all WorkSpaces. We would like to identify, through SQL, any users that are creating folders on these WorkSpaces.
Does anyone have any insight into this? Your help would be greatly appreciated. Thank you.
Find more posts tagged with
Comments
dabird
Can you use the PRJ_OWNER field in the PROJECTS table? This field represents the user who created the folder. You can locate folders belonging to a specific workspace by using the PRJ_PID field, where PRJ_PID = workspace id.
Make sure that you don't perform any kind of update to your tables directly; otherwise you might have trouble getting support from IWOV if something goes awry.
