There's a few cases where knowing how to find duplicates is to your advantage. The quickest way to find duplicates from the database is via the CLI. Here's a few example SQL commands:If you want to get a list of just the unique types:# SELECT typeFROM apGROUP BY type HAVING count(*)>1;-here the SQL query is showing just the unique types (removing the duplicate)If you're looking for unique group names:# SELECT id, nameFROM ap_groupWHERE id IN (SELECT ap_group_idFROM apGROUP BY ap_group_id HAVING count(*)>1)ORDER BY name;-here the SQL query is showing just the unique group names (removing the duplicates)If you want to get a list of the devices reporting duplicate IP addressss:# SELECT id, name, apparent_ipFROM apWHERE apparent_ip IN (SELECT apparent_ipFROM apGROUP BY apparent_ip HAVING count(*)>1)ORDER BY apparent_ip;-here the SQL query is going to only show the duplicate entries by IP addressIf you want to get a list of the devices reporting duplicate MAC addresses:# SELECT id, name, lan_macFROM apWHERE lan_mac IN (SELECT lan_macFROM apGROUP BY lan_mac HAVING count(*)>1)ORDER BY lan_mac;-here the SQL query is going to only show the duplicate entries by MAC addressThats a few ways to get data when a duplicate is being reported. We've seen duplicates come up when clicking the "apply" or "save" option multiple times while the AMP is processing the command. We've also seen duplicates when using the replace device option or when restoring a backup runs into a disk error.
© Copyright 2024 Hewlett Packard Enterprise Development LPAll Rights Reserved.