dominique

Hello,

For 5.5
The table names have changed AeXInv_Aex_AC_Identification, AeXv_Computer but the structure remains.

The selection should look like this:

Duplication Name:

SELECT Ident.[Name], Ident.[Domain] FROM AeXInv_Aex_AC_Identification Ident
INNER JOIN
(
SELECT Ident1.[WrkstaId], Ident1.[Name], Ident1.[Domain] FROM AeXInv_Aex_AC_Identification Ident1
INNER JOIN AeXInv_Aex_AC_Identification Ident2 ON Ident2.[Name] = Ident1.[Name] AND Ident2.[Domain] = Ident1.[Domain] AND Ident2.[_id] != Ident1.[_id]
INNER JOIN AeXv_Computer Ident3 ON Ident1.[WrkstaId] = Ident3.[WrkstaId]
GROUP BY Ident1.[WrkstaId], Ident1.[Name], Ident1.[Domain]
) udr ON Ident.[WrkstaID] = udr.[WrkstaID]
GROUP BY Ident.[Name], Ident.[Domain]

Duplication on Serial Number:

SELECT Ident.[Serial Number], Ident.[Computer Model] FROM AeXInv_Aex_HW_Serial_Number Ident
INNER JOIN
(
SELECT Ident1.[WrkstaId], Ident1.[Serial Number], Ident1.[Computer Model] FROM AeXInv_Aex_HW_Serial_Number Ident1
INNER JOIN AeXInv_Aex_HW_Serial_Number Ident2 ON Ident2.[Serial Number] = Ident1.[Serial Number] AND Ident2.[Computer Model] = Ident1.[Computer Model] AND Ident2.[WrkstaId] != Ident1.[WrkstaID]
INNER JOIN AeXv_Computer Ident3 ON Ident1.[WrkstaId] = Ident3.[WrkstaId]
GROUP BY Ident1.[WrkstaId], Ident1.[Serial Number], Ident1.[Computer Model]
) udr ON Ident.[WrkstaID] = udr.[WrkstaID]
GROUP BY Ident.[Serial Number], Ident.[Computer Model]

Thanks,
Dom