Bios information

[wgknowles]

Perhaps I'm blind, but I can't seem to find the Bios information within the Configuration Browser!?
I see the information is in tblBIOS, but it doesn't seem to be presented anywhere in the Website.

One suggestion for a prepackaged report would be "Out of date BIOS" This may be hard to keep up to date for all mfg's but I'm interested in DELL Bios versions in particular.

As of the time of this post I know about these versions:

Optiplex GX260 - A09
Optiplex GX270 - A07
Optiplex GX280 - A08
Optiplex GX620 - A11
Optiplex 745 - 2.6.2
Optiplex 755 - A14
Optiplex 760 - A03

Anyone savvy enough to write a report to let me know if I need to go update the BIOS on one of these models?
I'm sure I could modify the report on my own to reflect new BIOS releases.

I've attached a sanitized listing of some sample computers to assist in the design...
On closer inspection, perhaps the A0x isn't the appropriate field to use?
Perhaps the ReleaseDate would be easier to do a less than operator on?

[crashcarr]

I was looking for the bios information in the web interface in 3.5.2 and still am not seeing it. Was it scrapped or am I just looking in the wrong place? Thanks, James

[Hemoco]

crashcarr wrote:
I was looking for the bios information in the web interface in 3.5.2 and still am not seeing it. Was it scrapped or am I just looking in the wrong place? Thanks, James

The previous version number was wrong, it will be in 4.0

[wgknowles]

Think I figured it out, the first view gives you a list of the most up-to-date BIOS found on your network for each computer Model
The second view references the first, and tells you which computers need to be updated.

These reports update themselves as the scans discover new BIOS releases on your network.

View 1: Find Latest Bios Version (web30repMaxBiosVersion)
Select top 100 percent Query.Model, max(Query.SMBIOSBIOSVersion) LatestRev, Max(SubString(Query.ReleaseDate, 1, 8)) MaxReleaseDate From ((Select tblBIOS.ReleaseDate, tblBIOS.SMBIOSBIOSVersion, tblComputersystem.Model From tblComputersystem Inner Join tblComputers On tblComputers.Computername = tblComputersystem.Computername Inner Join tblBIOS On tblComputers.Computername = tblBIOS.Computername)) Query Group By Query.Model Order By Query.Model

View 2: Display Computers with Out of Date BIOS
Select dbo.tblBIOS.Computername, tblComputersystem.Model, dbo.tblBIOS.SMBIOSBIOSVersion InstalledBIOS, web30repMaxBiosVersion.LatestRev LatestBIOS From dbo.tblBIOS Inner Join tblComputersystem On dbo.tblBIOS.Computername = tblComputersystem.Computername Inner Join web30repMaxBiosVersion On tblComputersystem.Model = web30repMaxBiosVersion.Model Where dbo.tblBIOS.ReleaseDate < SubString(web30repMaxBiosVersion.MaxReleaseDate, 1, 😎


This should work with all Computer Models, but I only have Dells to test with here... Curious if there is a better field then tblComputersystem.Model to reference when it comes to knowing which BIOS you have.

[Hemoco]

wgknowles wrote:

This should work with all Computer Models, but I only have Dells to test with here... Curious if there is a better field then tblComputersystem.Model to reference when it comes to knowing which BIOS you have.

If you have only dell computers then you are always correc to use the model.

[Hemoco]

This would work if at least one of your computers had the latest bios.

[wgknowles]

I was thinking about this last night and had the realization that this report could update itself by simply creating another view that queries the MAX(dbo.tblBIOS.Releasedate) for each Model. The original query could then reference this one in a join.

[Hemoco]

Maybe easier would be to create a new custom table with fields (computermodel,latestbios)
You can then just link this to the other table.

[wgknowles]

Wow, I guess I still remember SQL a little bit 😃
Any suggested modifications?
I'd really like to be able to include a 4th column that includes the "current" bios version.
How can i have this be conditional on the computer model?


SELECT TOP (100) PERCENT dbo.tblComputers.Computername, dbo.tblComputersystem.Model, dbo.tblBIOS.SMBIOSBIOSVersion AS 'Installed Bios'
FROM dbo.tblBIOS INNER JOIN
dbo.tblComputers ON dbo.tblBIOS.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername
WHERE (SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20060626) AND (dbo.tblComputersystem.Model LIKE 'OptiPlex GX270') OR
(SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20060303) AND (dbo.tblComputersystem.Model LIKE 'Optiplex GX280') OR
(SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20061130) AND (dbo.tblComputersystem.Model LIKE 'Optiplex GX620') OR
(SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20080812) AND (dbo.tblComputersystem.Model LIKE 'Optiplex 745') OR
(SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20090624) AND (dbo.tblComputersystem.Model LIKE 'Optiplex 755') OR
(SUBSTRING(dbo.tblBIOS.ReleaseDate, 1, 😎 < 20090616) AND (dbo.tblComputersystem.Model LIKE 'Optiplex 760')
ORDER BY dbo.tblComputers.Computername

[Hemoco]

The bios on the web interface will be in version 3.5.2.