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 

Import already registered computers or Users in SCCM 2012 using a file to a collection

How to import already registered computers or Users in SCCM 2012 using a file a file to a collection. It’s easy to import a computers from a CSV file with NetBIOS name and MAC address but importing computer which are already registered to console is bit difficult. There are situations when a collection needs to be created and no query seems working in those situation a manually add resource option is left out which is time taking.

To automate/import registered computer to a collection using a file, I followed below steps which seems to be working for me…

Create list of computer which needs to be imported then have them comma separated using below steps and finally add resources to the collection.

The objective is to arrange it in a comma separated way so that it can be imported in a single shot rather doing one by one.

Output should be username01, username01 etc.

Now select the collection Right click à Add resources à Copy computer names (comma separated) under Name String Contains à SearchàSelect allàAddàOK.

Refresh the collection and should be populated with computers shortly.

SCCM 2012 Report for Internet Explorer(IE) versions

If you looking for a reports for IE versions using SCCM. Please try Out of the Box reports, this is easy, accurate and reliable report i have found so far. I have tried custom reports as well.

Here are the steps..

Open SCCM Console Navigate to

Monitoring--> Reporting-->Reports --> Search--> Type "Computers with a specific file"

Double click the report Type "iexplore.exe" under file Name and click View report.

Export as excel and short it with file versions you need.

Thanks