Find Duplicate Records Name in CMDB Server List

[Mohamed Faizel]

Hi,

I would like to get the duplicate records in "cmdb_ci_win_server" table by name, Is there any way to get it, Please help on on this. I tried some background scripts but those are not working.

Thanks,

Mohamed Faizeal.

[nkduodu]

Hi Mike/All,

is there a way to search for CI records with same names but say different domain names?

eg :

LXRSVESRSP02

lxrsvesrsp02.infoconsult.com

i want to be able to generate a report showing servername like the above

[Mike Allen]

I would either group by name in a list view:

Or write a script that tells you that.

[nkduodu]

Thanks Mike. With regards to scripting, i'm guessing there's no Out of the Box scrpt to modify, right?

I'm new to ServiceNow and an end-user not an admin. The Group by Name is doable but kinda hard to use for a company with 15,500 server CI records.

[Mike Allen]

The script would have to come from your admins.   I don't know of a way to do this outside this group by to do it in ServiceNow.   You can pull the data and massage it in Excel, possibly.

[Balaji Ramanath]

Hi Mike, how to display only duplicate records grouping by name?