automatically add computer in device collection

Question

automatically add computer in device collection

Anonymous

Hi Team, I want to add computer automatically to a device collection based on buildnumber 19044 I created the next query, but it do not find the required computers: 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "19044" ![174059-add.png][1] [1]: /api/attachments/174059-add.png?platform=QnA I tried it with '19044', 10.0 (19044) or with select * from SMS_G_System_OPERATING_SYSTEM where where SMS_G_System_OPERATING_SYSTEM.BuildNumber = '19044' Could someone have more ideas how to fix this?

Eswar Koneti 2,096 Reputation points

2022-02-14T14:10:04.82+00:00

no issues with the query syntax. it looks like you dont have any devices with the build number that you are looking for.
You can run the following SQL query if any records with the build number 19044

select top 10 * from v_gs_operating_system os where os.buildnumber0='19044'

Thanks,
Eswar
www.eskonr.com
Anonymous

2022-02-14T17:36:26.147+00:00

Hi @Eswar Koneti , nice to know that the query syntax is good. where do I need to run your sql query? from SCCM it is failing. here is an example of one device in AD ![174165-version.png][1] [1]: /api/attachments/174165-version.png?platform=QnA

Eswar Koneti 2,096 Reputation points

2022-02-14T14:10:04.82+00:00

no issues with the query syntax. it looks like you dont have any devices with the build number that you are looking for.
You can run the following SQL query if any records with the build number 19044

select top 10 * from v_gs_operating_system os where os.buildnumber0='19044'

Thanks,
Eswar
www.eskonr.com
Anonymous

2022-02-14T17:36:26.147+00:00

Hi @Eswar Koneti , nice to know that the query syntax is good. where do I need to run your sql query? from SCCM it is failing. here is an example of one device in AD ![174165-version.png][1] [1]: /api/attachments/174165-version.png?platform=QnA

Answer 1

AllenLiu-MSFT 24,131 Microsoft Vendor

Hi, anonymous user

Thank you for posting in Microsoft Q&A forum.

SMS_R_System also has the build info, and the info is from heartbeat discovery, but the build info in SMS_G_System_OPERATING_SYSTEM is from hardware inventory, I think you have not enable the hardware inventory because no info in your Resource Explorer, so you may use the query like this:

Select * from SMS_R_System where SMS_R_System.Build="10.0.19044"

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Anonymous

2022-02-15T08:25:09.603+00:00

Hi @AllenLiu-MSFT ,
I have tried the query already, but maybe the solution is indeed enable the hardware inventory.
will try this out and let you know.
AllenLiu-MSFT 24,131 Reputation points Microsoft Vendor

2022-02-15T08:31:42.483+00:00

Hi, anonymous user

If you haven't enable hardware inventory, you may start from here:
https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/inventory/configure-hardware-inventory

And after hardware inventory, your query will get the same results as my query if you do not upgrade any clients recently.
Anonymous

2022-02-15T23:24:23.85+00:00

hardware inventory was already enabled @AllenLiu-MSFT ![174579-hardware.png][1] Also run inside configuration manager the hardware inventory cycle. ![174672-hardware1.png][2] [1]: /api/attachments/174579-hardware.png?platform=QnA [2]: /api/attachments/174672-hardware1.png?platform=QnA Not sure what I could do now.. the query is not working
AllenLiu-MSFT 24,131 Reputation points Microsoft Vendor

2022-02-18T07:27:44.393+00:00

The default hardware inventory schedule is 7 days, it's not recommended to set it less than 1 day because it will cause some unwanted issue, you may refer to Garth's suggestion to run a full hardware inventory.

Answer 2

Anonymous

I changed the query to look for the OU instead of the buildnumber.
It worked now fine!

AllenLiu-MSFT 24,131 Reputation points Microsoft Vendor

2022-02-17T01:51:16.343+00:00

Is it work when you use the query?
Select * from SMS_R_System where SMS_R_System.Build="10.0.19044"
Anonymous

2022-02-18T08:44:32.907+00:00

Hi @AllenLiu-MSFT
No it did not work, but I changed the query to look for computers in an OU instead and that query works fine for me.

I can not put my solution as answer for my question.

I believe some querys would not work in specific versions of mecm.
AllenLiu-MSFT 24,131 Reputation points Microsoft Vendor

2022-02-18T08:50:46.287+00:00

Glad to hear that you found the solution, I'm just curious have you enabled the heartbeat discovery?
Anonymous

2022-02-18T18:31:18.247+00:00

! [175925-heartbeat.png][1] [1]: /api/attachments/175925-heartbeat.png?platform=QnA Yes it is enabled

Answer 3

Garth Jones 1,291

On a computer with that version, have you reviewed Resource Explorer to confirm that it shows that version?

Anonymous

2022-02-14T14:16:41.187+00:00

at this moment Resource explorer is reading zero information about an device..
Garth 4,756 Reputation points MVP

2022-02-15T00:00:06.01+00:00

Follow this blog. https://www.recastsoftware.com/resources/updated-troubleshoot-configmgr-hardware-inventory-issues/

Answer 4

Every one minute for hw inventory is far too often and may cause problems. Set it to once a day.

Since you have set this to once a minute you might need to force a full hw inventory on all of your computers.
https://www.recastsoftware.com/resources/updated-how-to-perform-a-full-hardware-inventory-of-a-pc-collection-the-easy-way/

automatically add computer in device collection

3 additional answers

Activity