I'm looking for an easy way to identify Document Type creation. I thought it would be easy enough to query the configlog table, but what I find is that a LOT of our document type creation actions are missing from the table. I would expect that every document type creation would have an entry, but that just not the case. What am I missing? Is there another table that might contain the missing doc types? From what I can see, column extrainfo1 contains the Doc Type ID, but I don't find what I expect.
Here's the query:
SELECT
[logdate] as [Log Date]
,[messagetext]
, cl.[usernum] as [OnBase User Number]
, trim(ua.realname) as [User Real Name]
,[extrainfo1] as [Document Type ID]
,trim(dt.itemtypename) as [Document Type Name]
,[actionnum]
,[subactionnum]
, REPLACE (REPLACE ([dti].[departmentuse], CHAR (10), '/'), CHAR (13), '/') AS [Department Usage]
, REPLACE (REPLACE ([dti].[documentsource], CHAR (10), '/'), CHAR (13), '/') AS [Source of Document]
, REPLACE (REPLACE ([dti].[businessapp], CHAR (10), '/'), CHAR (13), '/') AS [Business Application]
, REPLACE (REPLACE ([dti].[workflowuse], CHAR (10), '/'), CHAR (13), '/') AS [Workflow]
FROM [OnBase].[hsi].[configlog] cl
left outer JOIN hsi.useraccount ua on ua.usernum = cl.usernum
left outer JOIN hsi.doctype dt on dt.itemtypenum = cl.extrainfo1
LEFT OUTER JOIN [hsi].[doctypeinfo] AS [dti] ON [dt].[itemtypenum] = [dti].[itemtypenum]
where messagetext like 'Created new entry - Document Types (%'
order by extrainfo1 desc