/build/static/layout/Breadcrumb_cap_w.png

Purge Duplicate Records

Hi everyone,

I used the SQL statement (below) to search for a particular machine and instead of it returning a single record, it returns 31 of them that are clearly the same machine (based on the output also shown below where MAC, etc are the same across the board, but only the KUID differs).

Is there a way to remove duplicate records like this or can anyone explain why these dupes may have happened in the first place? Something to note is that there are known WMI issues in this environment. We are using a script from the K1000 to attempt to correct these WMI issues, but are having mixed luck.

SQL Statement:

SELECT M.MAC, M.IP, M.KUID, M.NAME, M.OS_INSTALLED_DATE FROM MACHINE M
where M.IP LIKE "10.7.5.215"
order by KUID;

Output:

MAC IP KUID NAME OS_INSTALLED_DATE
00:12:3F:2D:AB:30 10.7.5.215 057B3ABC-A176-4DCE-AB73-74305607D171 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 0E827FD9-DEA4-4DB1-B10A-BB8A8CDF2C9F AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 10E0287B-3E7E-4FEC-88A1-11EC35E16F96 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 24FD7187-7345-46C6-9494-2F006C197D61 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 2B711385-D041-4478-A777-1CA67B4B8A07 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 5869E8FC-D22F-48FC-ADAE-0564C22FE9BB AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 5CC829B0-324D-462B-A61E-F07B2BE27B6B AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 5D968555-83CD-490C-A2C4-AF055624277E AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 5DC21556-7FA7-4EA4-88B1-B09E02B3572C AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 5E398D3A-632E-40FA-A647-D88DB920FC35 AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 5EB16DD2-4AE9-430F-AC15-3D3F44DE51D5 AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 6BADB52B-73C6-4C53-A6C2-E3B8984A5980 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 6DBD7F45-A99D-4BA1-B926-76E3EF2A6192 AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 7068DBCA-6777-43D5-AF1B-E881AFB64B8C AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 767F1716-F376-428C-960D-4E8D04A2534B AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 8495E419-6452-4307-9283-86202D9849AE AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 84CB73F3-BFC5-4FE1-89D8-C983F09F455A AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 8AC9C139-2777-4806-BB5B-F678D0831F76 AHS-E1-TEACH 6/29/2007 12:55
00:12:3F:2D:AB:30 10.7.5.215 8D1D361E-125D-4E51-BD5E-1C04C08E4E2D AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 8E63D958-4596-4763-954A-BE34CC56A3E2 AHS-E1-TEACH empty
10.7.5.215 957CAAFB-5511-440B-BD6E-3D3C10AF5212 AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 B49E18C6-3E74-4208-8A69-771AA9ADAD75 AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 BA192B40-6E04-44C8-A404-D1A483DD4428 AHS-E1-TEACH empty
10.7.5.215 BADB9520-B4D2-446C-889F-F0CA21BB745F AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 CA5F12DA-BDAB-4841-9124-74CD0F9A19B1 AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 CB517224-D784-4926-AB5A-72231310B907 AHS-E1-TEACH empty
10.7.5.215 D576B04B-41E4-4999-B86D-25F85916B2B5 AHS-E1-TEACH empty
10.7.5.215 F4D2BC06-BB9F-455C-9F8B-3AE99C8C029A AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 F8E5D7E8-55E5-4E0E-B447-9086EB891399 AHS-E1-TEACH 6/29/2007 12:55
10.7.5.215 FC99C747-0A07-4B23-A930-237348F23D71 AHS-E1-TEACH empty
00:12:3F:2D:AB:30 10.7.5.215 FE877843-2C24-41AA-8EEE-760A138997FE AHS-E1-TEACH 6/29/2007 12:55

Thanks so much!

-Alex

0 Comments   [ + ] Show comments

Answers (2)

Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
This should help you out http://www.kace.com/support/kb/index.php?action=artikel&cat=3&id=673&artlang=en
Posted by: ATKlein 13 years ago
Senior Yellow Belt
0
Gerald, you are SO on my Christmas list. Thank you!!! -Alex
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ