SQL statement to verify that all actions are logged

1

Hi everyone,

I just stumbled about an action which executions hasn't been logged. The reason is simple, the according checkbox wasn't ticked.

If you want to verify that all you actions are logged you can run this SQL statement. It displays all actions which aren't logged. Maybe for a reason or due to some misconfiguration:

SELECT AGR_Name, APP_Name, DEF_Name, WF_Name, STP_Name, ACT_Name
FROM [dbo].[WFActions] actions join WFSteps on ACT_STPID = STP_ID
join WorkFlows on STP_WFID = WF_ID join WFDefinitions on WF_WFDEFID = DEF_ID
join WFApplications on DEF_APPID = APP_ID
join WFApplicationsGroups on APP_AGRID = AGR_ID
where ACT_LogExecution = 0 and ACT_IsDeleted = 0
order by AGR_Name, APP_Name, DEF_Name, WF_Name, STP_Name

Even so it's tempting, you shouldn't use an SQL statement to change these. :)

Best regards,
Daniel