portafreak
New Member.
1075 views

Remove duplicates entry in Database

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.
Labels (1)
0 Likes
5 Replies
Not applicable

Re: Remove duplicates entry in Database

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.
0 Likes
portafreak
New Member.

Re: Remove duplicates entry in Database

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
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Remove duplicates entry in Database

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.
0 Likes
portafreak
New Member.

Re: Remove duplicates entry in Database

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.
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Remove duplicates entry in Database

That is the Audit DB, you don't want to alter that.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.