Create SCCM collection based on Model and BIOS Version

lalajee 1,821 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 Security | Intune | Configuration Manager | Application
Microsoft Security | Intune | Configuration Manager | Other
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Sherry Kissinger 5,526 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 No 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 No comments

  3. ESWARARAJU KONETI 2,206 Reputation points MVP Volunteer Moderator
    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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.