Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

SQL report for BIOSReleaseDate

Matt Jones

May 19, 2016 20:11

I have built a Scan Profile to scan HKLM\HARDWARE\DESCRIPTION\System\BIOS where the BIOSReleaseDate value is stored.

I am now trying to run a report that shows Computer Name and BIOS Release Date (and a lot of other information) and I cannot seem to pull the value for BIOSReleaseDate.

Line 25 in the attached text file is where the failure occurs, it just returns a blank column. Everything works great before and after that line.

Any help would be appreciated.

sql.txt

Comments

1 comment

Shane Corellian
May 20, 2016 06:02

I haven't run your SQL script but after looking it over you should change the following:

(SELECT RegistryEntries.Value WHERE RegistryEntries.Value = 'SystemBiosDate')

to

(SELECT RegistryEntries.Value WHERE RegistryEntries.Name = 'SystemBiosDate')

0