Share via

Creation of collections and their architecture

Rafael Aguilar 496 Reputation points
2020-08-27T19:20:56.96+00:00

Hi Team.

I have this detail in my client:

I have a total of 551 pieces of equipment in one location, a dynamic collection.
20898-image.png

Generating a query and adding its architecture decreases that amount to 497.

21032-image.png

21033-image.png

Why does this happen? You should show me this way the field is empty the total of 551 equipment.

Thanks for your help

Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rafael Aguilar 496 Reputation points
    2020-08-28T02:36:34.223+00:00

    Hi.

    I discovered that this "SMS_G_System_COMPUTER_SYSTEM.SystemType" attribute is NULL, that's why it doesn't bring me all the computers since some of them don't have that attribute.

    This attribute is fed by the hardware inventory?

    0 comments
  2. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2020-08-28T03:15:30.53+00:00

    Thank you for posting in Microsoft Q&A forum.
    Your collection MX-All Desktop and Server Client is limited to collection All Systems, the collection All Systems contains all unknown computers and all provisioning devices:
    21095-29.jpg

    However, the query you used is select * from SMS_R_System,
    it will not contain the unknown computers and provisioning devices.
    21131-30.jpg

    If the response is helpful, please click "Accept Answer" and upvote it.