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
Sunday, 7 March 2021

Tags: report find computer name with SMS GUID

SCCM report find computer name with SMS GUID:

Posted on July 14, 2009 by Eswar Koneti | 4 Comments | 5,433 Views
  Select  Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from dbo.v_GS_SYSTEM Sys Where   Sys.SMSID0 = @GUID Prompt for GUID: select SMS_Unique_Identifier0 from v_R_System
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.