Most Recent Discovery date and updated date Behaviour

[Adarsh kumar si]

Hello team,
I have requirement ,During upload of file if there are no changes to record then "most recent discovery date" should be updated only but not "updated" date.
Incase of any changes of any records (except most recent discovery) then "updated" date should update.

Please let me know if anyone have solution.
Thank you.

[srinija_itom]

Hi @Adarsh kumar si , 

I don't think this requirement is achievable as ootb most discovery field is updated whenever discovery runs on a device/server. If you alter this logic, we are modifying the ootb logic which is  not considered as best practice.

If you are looking into cmdb_ci_config_file_tracked_list.do table, then there is field called Last modified which you can leverage for your scenario. 

There is more field called File Size in bytes you can consider this field as well. which can be a good indicator of content change.

Please mark as the solution as helpful or the accept solution if this solves your query.

Regards,

Srinija

[Adarsh kumar si]

Hello @srinija_itom  Thanks for your response,
But my requirement is for cmdb_ci_business_app table where i have to restrict updated field when there are no changes to any record. Only most recent discovery should be updated.

Whereas,
If any records are changed (except most recent discovery) then only updated date should update.

Thank you.