Remove duplicates entry in Database

[portafreak]

Hi,

We have some duplicate hostnames in the dbo_ZDEVICE_REF. Is there any way to remove the old one without deleting them directly in the DB?

Thank you.

[strj500]

Can you show some examples of the duplicates?

I would ensure that you have the "Enable automatic renaming of devices" enabled in the registration configuration.

[portafreak]

The hostname 'D2510-PR' with DEVICEID 0x09635CF212CE1F08F9D52A76CC9A9B6C is the one I want to remove for good.

SELECT * FROM [ZENworksAudit].[dbo].[ZDEVICE_REF] WHERE HOSTNAME = 'D2510-PR'


DEVICEID HOSTNAMELOCATION NAME OSNAME OWNER PARENT_PATH PATH ROLE SITE SUBTYPE ZUID idcol
0x09635CF212CE1F08F9D52A76CC9A9B6C D2510-PR D-2510 D2510-PR windows7-pro-sp1-x64 NULL NULL /devices/workstations/Clients/Salles de classe/D/D-2510/D2510-PR Managed Workstation 0x8BB4DB417D7A8A468B540211FD6D49E2 1034
0x8C9379E04A3D60050D5C43BCEB550684 D2510-PR D2510-PR windows7-pro-sp1-x64 NULL NULL /devices/workstations/Clients/Salles de classe/D/D-2510/D2510-PR Managed Workstation 0x87ECCD75E8703E49B4581C69D3726462 1040

We do have the renaming of devices enabled:

https://i.imgur.com/xSMghe8.png

[CRAIGDWILSON]

That is the AUDIT database....
Historical Records of Past Events.....
It shows what has Happened in the past in your zone.

Usually best to not try altering the databases outside of the ZCM interface.....
And in this case...there are not any duplicate entries or values that need to be deleted.

[portafreak]

That's why I'm posting, I did not alter the database. I'm looking for a way to do it with the ZCM interface.

[CRAIGDWILSON]

That is the Audit DB, you don't want to alter that.