Close Menu
    Facebook X (Twitter) Instagram
    Monday, May 19
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM report to list the Computer based on Given GUID

    SCCM report to list the Computer based on Given GUID

    Eswar KonetiBy Eswar KonetiJanuary 12, 5:06 am1 Min Read Collections 3,466 Views
    Share
    Facebook Twitter LinkedIn Reddit

    There are some warnings under component system for MP_control_manager bcz of client machine are not approved and MP is rejecting the policys that are requesting from the client (MP has rejected a policy request from GUID:d0400dcb-68a9-4b64-92af-daa70db2a53a because it was not approved. The operating system reported error 2147942405: Access is denied.) It might be difficult in finding a system in a large number of systems based on GUID.

    Create a new report and paste the following qeury into the report:

    Select
        Sys.Name0,
        Sys.SMSID0,
        Sys.Domain0,
        Sys.SystemRole0
    from
        dbo.v_GS_SYSTEM Sys
    Where
        Sys.SMSID0 = @GUID

    Prompt:

    select SMS_Unique_Identifier0 from v_R_System

    Collections
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    Investigating SCCM Client Policy Request and Communication Status with a Collection Specific Report

    October 15, 11:22 pm

    SCCM Collection for AAD joined devices (co-managed)

    February 05, 11:34 pm

    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-2024 Eswar Koneti, All rights reserved.

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