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
Wednesday, 18 May 2022

Tags: computer name with SMS GUID

SCCM report find computer name with SMS GUID:

Posted on July 14, 2009 by Eswar Koneti | 4 Comments | 6,982 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

Awards

  • Latest
  • Popular
  • Comments
  • Download ConfigMgr builds while the evalcenter links are fixed

    Download ConfigMgr builds while the evalcenter links are fixed

    May 11, 2022
  • How to upgrade the Intune certificate connector

    How to upgrade the Intune certificate connector

    April 26, 2022
  • SCCM Software Update installation failed with error code 0x87D00664

    SCCM Software Update installation failed with error code 0x87D00664

    March 22, 2022
  • How to deploy Microsoft Store apps (offline) using Microsoft Endpoint Manager

    How to deploy Microsoft Store apps (offline) using Microsoft Endpoint Manager

    March 3, 2022
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • 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 report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • Eswar Koneti You can download the powershell script using https://eskonr.
  • Jeffrey Lawrence Kilmer Eswar, is this PowerShell script still available?
  • Harender Jangra I was also facing this issue then I found there were two upd
  • Eswar Koneti Hi, Serial number is not listed as an attribute in the dynam

.

Subscribe to Blog via Email

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

Join 7,353 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-2022 Eswar Koneti , All rights reserved.