Question:
Where are custom fields stored in the Database? Is there a way to track who created them or when?
Answer:
They are in Config_Objects under the Metadata Root:
SELECT * FROM config_objects where parent = '\VED\Metadata Root'
With a little creativity, we can find out what each of these are called and when they were created:
Select cc.AttributeValue, co.CreatedOn
from config_contains cc join config_objects co on cc.objectID = co.id
where co.parent = '\VED\Metadata Root' and cc.Attribute = 'Label Text'
Comments