Close Menu
    Facebook X (Twitter) Instagram
    Saturday, October 11
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report find computer name with SMS GUID:

    SCCM report find computer name with SMS GUID:

    Eswar KonetiBy Eswar KonetiJuly 14, 4:26 pm1 Min Read SCCM 2007 9,000 Views
    Share
    Facebook Twitter LinkedIn Reddit

     

    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

    computer name with SMS GUID Configmgr 2007 configmgr report GUID MySQL Vs SQL Server report find computer name with SMS GUID SCCM SCCM 2007 SCCM Reports SMS
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    4 Comments

    1. vrushab h on October 22, 2013 7:41 PM

      This query did not work for me, need a help.

      Reply
      • Eswar Koneti on October 29, 2013 7:43 PM

        how are you providing the GUID ? you should supplay GUID in report prompt ?
        what is not working for you ?

        Reply
    2. vrushab h on October 22, 2013 7:35 PM

      Hey Eswar this query did not work for me/..

      Reply
      • Eswar Koneti on October 29, 2013 7:51 PM

        how are you providing the GUID ? what is not working for you ?

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

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

    Type above and press Enter to search. Press Esc to cancel.