All about Microsoft Endpoint Manager
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
  • SCCM Reports
  • Intune
  • About Author
Monday, 8 March 2021

Tags: conflict records

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

Posted on May 31, 2019 by Eswar Koneti | 1 Comment | 12,841 Views
I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname. So i started looking at this issue to see how identify the records with duplicate hostnames. SCCM clients are uniquely identified by a GUID. A…
Read more »

Eswar Koneti

Looking for Consulting services?

Awards

  • Latest
  • Popular
  • Comments
  • Audit messages for software update deployments in Configuration Manager

    Audit messages for software update deployments in Configuration Manager

    March 5, 2021
  • Did you miss to download your samples from Technet Gallery Here is how you can do it.

    Did you miss to download your samples from Technet Gallery Here is how you can do it.

    February 27, 2021
  • Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    February 9, 2021
  • SCCM Collection for AAD joined devices (co-managed)

    SCCM Collection for AAD joined devices (co-managed)

    February 5, 2021
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    March 25, 2010
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • SCCM report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • Eswar Koneti Thank you. Blogpost is updated. Regards. Eswar
  • Eswar Koneti Hi, Please follow this link to download the Technet Gallery
  • Sooraj Hi Eswar Is this link working? https://gallery.technet.micro
  • mattmn Good blog post. Microsoft added three more types. Tablet (30

.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7,118 other subscribers

@eskonr on Twitter

Tweets Eswar

All Rights Reserved

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Archives

.

© Copyright 2009-2021 Eswar Koneti , All rights reserved.