De-Duplicating Hardware Models

Jbelter · ‎02-26-2024

What has been other peoples solutions to de-duplicating Hardware Models? I was looking at this KB article:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0999448
But the issue I see with this is - it is a one-time fix (unless I am missing something). This won't work for models that are created multisource CMDB. Data sources will bring in CI data (which normally includes the model) on a schedule (usually weekly/daily).

In these cases the original duplicate hardware model will just be recreated (or at least this is what I have seen in my experience).

My current solutions uses a script include that is called from a business rule that triggers on insert/update of the cmdb_hardware_product_model table. This way whenever a new model is created, it is de-duplicated against already existing models.

Have you guys experienced duplicate Hardware Model issues, and if so how did you solve them?

Lithesh · ‎02-27-2024

Hi @Jbelter,
From My point of view, I have faced this issue with the creation of multiple duplicate models because of multiple discovery sources. So what I did is the same as you I have configured the Business rule in the Model table so that before any new model record is created. It will check if the model is already available or not. If it's available, it won't create. If not, It will create a new model. To remediate the existing duplicates. I have configured a flow with a custom action where it will automatically find the duplicates and authenticated model against the duplicate and re associate them.

Thanks,
Lithesh

View solution in original post

jonsr20 · ‎05-07-2024

Can you share your business rule script?

Darkl1ght · ‎09-16-2024

Hi @Lithesh,

On what all attributes is your script checking if the Model is available or not. Also, could you mention the precedence of those attributes as well.

Lithesh · ‎09-17-2024

Hi @Darkl1ght,

Attribute I used to find whether the model is duplicate or not - Model number and Model Name.

Attributes I used to find the authenticated - Check which has maximum number of attributes populated and Check which has maximum assets with it.

Let me know if you have any further questions. If you feel this is helpful Mark my comment as helpful.

Thanks,

Lithesh

esebasti · ‎11-19-2024

@Lithesh Very informative, you wouldn't happen to be able to share an update set with your BR and Flow would you? Thanks

Lithesh · ‎11-25-2024

Hi @esebasti,

I have done this to my customer and I don't have them on any PDI. So I can only give idea about this I think even that can help someone on how to approach things. If they have good knowledge on scripting and ITAM.

Regards,

Lithesh