jfdensmore Posted August 31, 2018 Report post Posted August 31, 2018 I have a membership rule looking for clients equal to Operating system build 16299, it finds them, but it always includes 17134 builds too? I cant figure out why!!! Can anyone help? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 1, 2018 Report post Posted September 1, 2018 Can you please post the full query to be reviewed. Quote Share this post Link to post Share on other sites More sharing options...
jfdensmore Posted September 5, 2018 Report post Posted September 5, 2018 Sure, Thank you for taking a look at this! Do you want the Query Statement? 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 = "16299" Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 5, 2018 Report post Posted September 5, 2018 I see nothing wrong with that query and I tested it within my environment and it only shows 16299 build computers. I would update your query again and force the collection to update. Quote Share this post Link to post Share on other sites More sharing options...
jfdensmore Posted September 5, 2018 Report post Posted September 5, 2018 Ha, It's crazy i know , i have rebuilt it a few times, but it constantly returns the same group of 1803 computers. I have also verified that those computers were running 1803 as well. I don't know what the heck to do. Thanks a bunch for double checking my work though. Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 5, 2018 Report post Posted September 5, 2018 you have looked within Resource explorer and confirm what build number they are showing right? Quote Share this post Link to post Share on other sites More sharing options...
jfdensmore Posted September 5, 2018 Report post Posted September 5, 2018 Well, dang! How do you explain that? Indeed using resource explorer it is listed as 16299! So what is wrong here? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 5, 2018 Report post Posted September 5, 2018 I would force a full hardware inventory on one fo the PC to confirm that it has the correct data. if that works then force full hardware inventory on the whole collection. These blogs will help you with these tasks. https://www.enhansoft.com/?s=force+hardware+inventory 1 Quote Share this post Link to post Share on other sites More sharing options...
jfdensmore Posted September 5, 2018 Report post Posted September 5, 2018 Bingo! That is clearing them right up! Now my next question, what is causing that? My sccm clients are all up to date, and i didn't see any log files that identified this issue? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted September 5, 2018 Report post Posted September 5, 2018 Are you sure??? you will likely find that was not the case and the full inventory has "fixed" it. Quote Share this post Link to post Share on other sites More sharing options...
