Duplicate CMDB Tag Management

[JoeBaynham1]

Hi,

Does anyone have any experience with dealing with duplicate tags coming from scanning Azure or other cloud environments? We suffer quite significantly from poor tagging data quality and corrections are usually required on the tags inside our Azure estate. When tags of the same label are updated in Azure and Discovery / Azure SGC we then see a duplicate tag created in the CMDB tags rather than it being updated. Is there an out of the box solution to removing these duplicates, or should I go with my first thought of creating a business rule or some script to run to look for tags of the same label and configuration item and delete the oldest record? It seems like an oversight that the platform doesn't update the tag when it changes and instead creates a duplicate. 

Thanks,

Joe

[M Iftikhar]

@JoeBaynham1 ,

To fix what you already have, the first step is to clean up the current duplicates (e.g., by a business rule or scheduled job that checks for the same CI + tag label and deletes the oldest record). To prevent it from happening again, configure your Transform Map to coalesce on CI and tag label, or add a unique index on those fields so that updates overwrite instead of creating duplicates.

For the longer term, ServiceNow has introduced Real-Time Updates to Tags for Cloud Resources via the Cloud Events framework, check it out.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution and helpful so others can benefit as well.