Close Menu
    Facebook X (Twitter) Instagram
    Monday, May 12
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM configMgr collection computers do not contain letters in it

    SCCM configMgr collection computers do not contain letters in it

    Eswar KonetiBy Eswar KonetiDecember 21, 3:31 pm1 Min Read Collections 1,070 Views
    Share
    Facebook Twitter LinkedIn Reddit

    The collection listed below might help you to identify if any computers in organization that do not follow the standard naming convention .

    Below collection is created to list servers and do not contain specific words in computer name:

    select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System where (SMS_R_System.OperatingSystemNameandVersion like "%Server 6.%" or SMS_R_System.OperatingSystemNameandVersion like "%Server 5.%") and SMS_R_System.ResourceId not in (select ResourceID  from  SMS_R_System where SMS_R_System.Name like "%xxx%")

    The Logic is : list all servers with criteria given above and computer do not have xxx word in it.

    Please change the bold letters as per the requirement.

     

    Collection collection for no standard naming method configmgr devices with specific names do not contain name Microsoft SCCM SCCM System center configuration Manager WQL Quiry
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    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

    Investigating Co-Management Issues with Windows Endpoints in SCCM/Intune

    October 26, 10:45 pm

    2 Comments

    1. Chris on October 9, 2013 12:55 AM

      I cannot get this to work in SCCM 2007, it says the Query Rule has a Syntax Error, can you assist?

      Reply
      • Eswar Koneti on October 10, 2013 5:37 PM

        please replace the quotes('"),they are not computer quotes.

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

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