Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Notification Show More
Latest News
Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Disable Windows Hello for Business using Intune ftimg
Disable Windows Hello for Business using Intune – Comprehensive Guide
Intune Autopilot
Aa

Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

Aa
Search
  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Follow US

Home » SCCM » SCCM Device Collection for Desktop Central Agents

SCCMSoftware

SCCM Device Collection for Desktop Central Agents

By Prajwal Desai 4 Views Add a Comment May 30, 2021 3 Min Read

In this post I will show you how to create a SCCM device collection for desktop central agents in your setup. This might come handy when you want to find count of computers installed with desktop central agents.

Note that you can also find the count of computers installed with desktop central agents via the Desktop Central console. However when you have a device collection in SCCM, you can export the computers easily. In addition, when you have a device collection, you can perform tasks such as agent uninstall.

Before you create this collection, ensure the desktop central agents are deployed to the computers and the agents are active or online.

If you are looking to create a device collection for Windows 10 computers, take a look this post.

- Advertisement -
Ad image

SCCM Device Collection for Desktop Central Agents

To create a SCCM device collection for desktop central agents in SCCM.

  • Launch the Configuration Manager console.
  • Go to Assets and Compliance > Overview > Device Collections.
  • Right click Device Collections and click Create Device Collection.
  • Using Create Device collection wizard, add a query for Desktop Central agents.
"Create

On the General page of Create Device Collection wizard, enter the name of the device collection. Click Browse and specify the Limiting Collection. Click Next.

"Create

On the Membership Rules window, click Add Rule drop-down and select Query Rule.

Specify Query Rule
Specify Query Rule

Specify the Query name and click Edit Query Statement.

Edit Query Statement
Edit Query Statement

In the Query Statement Properties window, paste the below query.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "%manageengine"

Click OK.

Enter the desktop central agent query
Enter the desktop central agent query

After you add the query, click Next.

By default the Schedule a full update on collection is set to occur every 7 days. You may change it to run more frequently.

SCCM Device Collection for Desktop Central Agents Snap6

On the Completion page, click Close.

SCCM Device Collection for Desktop Central Agents Snap7

Finally go to Device Collections and verify the member count (desktop central agents) for the collection. It may take some time to update the count.

You may manually update the collection membership to speed up the process.

SCCM Device Collection for Desktop Central Agents
SCCM Device Collection for Desktop Central Agents

Sign Up For Weekly Newsletter

Get the most recent information on Configuration Manager, Intune, Windows 11, Windows 365, Autopilot, Azure, Software Reviews, and much more by subscribing to the newsletter.
By signing up, you agree and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
Share this Article
Facebook Twitter Copy Link Print
Avatar photo
By Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Enterprise Mobility. He writes articles on SCCM, Intune, Configuration Manager, Microsoft Intune, Azure, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Previous Article Failed to Extend SCCM Active Directory Schema Error 8202 Failed to Extend SCCM Active Directory Schema Error 8202
Next Article Configuration Manager Technical Preview 2008 Configuration Manager Technical Preview 2008
Leave a comment Leave a comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recast Sponsored AD
Ad image
Patch My PC Sponsored AD
Ad image

Latest Articles

Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Subscribe to Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

You Might Also Like

Recreate Database Tables in Rank Math
Software

How to Recreate Database Tables in Rank Math

By Prajwal Desai
Autofill Logins in Browser using Bitwarden Extension
Software

Autofill Logins in Browser using Bitwarden Extension

By Prajwal Desai
Find the Package ID of SCCM Application
SCCM

3 Best Ways to Find the Package ID of SCCM Application

By Prajwal Desai

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?