Good afternoon everyone,
Part of my company’s audit activities include running a query against the Ice.DashBdDef table monthly to show updates and deployments in production during that particular month.
SELECT [Company]
,[DefinitionID]
,[Description]
,[LastUpdated]
,[LastUpdatedBy]
,[LastDeployedDate]
,[LastDeployedBy]
FROM [EpicorERP].[Ice].[DashBdDef] where lastupdated >= '2022-02-28' and lastupdated < '2022-04-01' order by LastUpdated desc
We have a screenshot of this query being run in April for the month of March (specifically, where the LastUpdated column was between the dates of 2/28/2022 and 4/1/2022) and returning no results. If we run the same query for the same time period now, we get four records of updates done to dashboards on 3/1/2022 and 3/2/2022.
I’ve encountered scenarios where a Customization can show as being updated the first time a user runs it after a deployment to production (i.e., the Ice.xxxdef table gets a few updates when the first user goes to run the program in addition to the updates made when the program was deployed to the environment).
Is this also a possibility with Dashboards? Is there any other activity outside of deploying or saving in production that would update the LastUpdated column on Ice.DashBdDef?
Thanks!
Josiah