SOLVED SCCM Report for BIOS (legacy or UEFI)

[jibranbaig011]

Dear Concerns,
I am using below query for getting computers are using BIOS(legacy) or EFI/UEFI on SCCM 1702. Kindly confirm this query or anyone can share another sccm query for getting this report.
select * from SMS_R_System inner join SMS_G_System_FIRMWARE on SMS_G_System_FIRMWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_FIRMWARE.UEFI = 1

 

[Prajwal Desai]

Not sure if you have tried this script. Let me know if that doesn't work.

 

[Garth]

I can tell you that I'm working on a Dashboard set for this and one of the reports within the set will be a free giveaway in the coming months. This is what it looks like now.

 

[dj3094]

Hello garath, Is the report available?

 

[Garth]

Hello garath, Is the report available?

Each giveaway is only available for a month, that report is still available within the the Enhansoft Reporting. BTW this month's giveaway is Collection Details.