Tuesday, December 30, 2014

SCCM 2012 Query based Collection- Computers with a specific BIOS versions

WQL for Creating CM 12 Dynamic collection for Bios versions.


I have used this for Lenevo Bios versions...

select distinct SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET35WW (1.14 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET45WW (1.24 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET44WW (1.23 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET43WW (1.22 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET40WW (1.19 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET39WW (1.18 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET37WW (1.16 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET36WW (1.15 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET35WW (1.14 )" or SMS_G_System_PC_BIOS.SMBIOSBIOSVersion like "GFET28WW (1.07 )"

Corresponding query in  SQL will be..


select SMBIOSBIOSVersion0
FROM dbo.v_GS_PC_BIOS
where SMBIOSBIOSVersion0 Like 'GFET45WW (1.24 )' or SMBIOSBIOSVersion0 Like 'GFET44WW (1.23 )' or SMBIOSBIOSVersion0 Like 'GFET43WW (1.22 )' or SMBIOSBIOSVersion0 Like 'GFET40WW (1.19 )' or 

SMBIOSBIOSVersion0 Like 'GFET39WW (1.18 )' or SMBIOSBIOSVersion0 Like 'GFET37WW (1.16 )' or SMBIOSBIOSVersion0 Like 'GFET36WW (1.15 )' or SMBIOSBIOSVersion0 Like 'GFET35WW (1.14 )' or 

SMBIOSBIOSVersion0 Like 'GFET28WW (1.07 )'
ORDER BY SMBIOSBIOSVersion0 


No comments:

Post a Comment