query document type create date

[George_Tarasi]

Is there a table with information regarding when a Document Type was created?

[Nate_Anderson1]

Hi George-

You can run the following query to see when a document type was created:

select * from hsi.configlog where actionnum = 1 and subactionnum = 2 and messagetext like 'Created new entry - Document Types%'

The logdate will contain the date/time of when a document type was created. The extrainfo1 column will give you the document type number as well. 

Please let me know if you have any additional questions. Thanks!

[Andy_Miller]

FYI, this query only displays those doc types created from scratch. If you use the "Copy" feature, they will not display.