Create SCCM collection based on Model and BIOS Version

lalajee 1,811 Reputation points
2021-02-25T10:20:45.827+00:00

I need to create sccm device collection where model is dell 5400 but running BIOS version above 1.7.

I try below query but it didnt work after adding the BIOS version.

select distinct 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "Latitude 5400" and SMS_G_System_PC_BIOS.Name > "1.7"

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
474 questions
Microsoft Configuration Manager
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sherry Kissinger 4,211 Reputation points
    2021-02-25T13:06:13.69+00:00

    Is what is in Name the version? i.e. .... did you use the right field?

    PC_BIOS.Name > "1.7"

    1 person found this answer helpful.
    0 comments
  2. Garth Jones 2,076 Reputation points
    2021-02-25T12:08:03.24+00:00

    Why? What do you get? Also keep in mind the bios version is a string not a number.

    0 comments
  3. Eswar Koneti 2,201 Reputation points
    2021-02-25T18:42:31.383+00:00

    Are you looking for version or Name? try with the following.
    SMS_G_System_PC_BIOS.Version > "1.7"

    0 comments