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?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Team.
I have this detail in my client:
I have a total of 551 pieces of equipment in one location, a dynamic collection.
Generating a query and adding its architecture decreases that amount to 497.
Why does this happen? You should show me this way the field is empty the total of 551 equipment.
Thanks for your help
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?
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:
However, the query you used is select * from SMS_R_System,
it will not contain the unknown computers and provisioning devices.
If the response is helpful, please click "Accept Answer" and upvote it.