To Delete records in production

[Community Alums]

In Cmdb_ci_network table many records were created without Created date.

So we want to delete all the records which are empty in created date field. 

So how can we achieve this while deleting the records will this impact the reference data?i.e if we delete network gear records will the related asset gets deleted?

[Ashok Sasidhara]

If the records indicate valid CIs, I would recommend not to delete them as much as possible. If some of them are found to be duplicate CIs, make use of deduplication tasks to merge the data with other records for the same CI with better data. Only delete invalid CIs which are not yet referenced in any incidents, problems, changes etc.

But as the absence of 'Created' date seems like an unusual issue, please raise a hiticket with ServiceNow first to understand the root cause and also check if they are able to somehow populate the actual 'Created' date.

[Community Alums]

Hello Ashok,

in those records no data is there so by using background script we need to delete those records