Refine BIOS Update Relevance

[jgstew]

The dell catalog has an entry for Precision 3431 but in at least some cases, the actual model is reported as Precision Tower 3431 so then the relevance doesn't match.

This example was provided:

Q: exists values "product_name" whose(it as string as trimmed string as uppercase contains "Precision 3431" as trimmed string as uppercase) of structures "system_information" of smbios
A: False
T: 1.1000 ms
Q: ("Precision Tower 3431" as uppercase) = ((value "product_name" of structures "system_information" of smbios) as string as trimmed string as uppercase)
A: True
T: 4.000 ms

It may work to check that the model string starts with Precision and ends with 3431 but the model number MUST have a space before the numerals, because some models might be E7000 vs 7000 and the relevance needs to make sure to not think the BIOS update for model 7000 also applies to model E7000

It would be nice to have the unique set of results of (it as string as trimmed string) of values "product_name" of structures "system_information" of smbios across as many Dell / HP / Lenovo systems as possible to find these edge cases.

[suzib6sw]

Here is a list of all the unique models of all the makes seen using:

If (windows of Operating System) Then substring after "=" of (( select ("Model from Win32_Computersystem") of WMI ) as string) Else ( IF (mac of Operating System) Then string "model" of dictionary of service plane of iokit registry Else "N/A")

in an analysis..
Machine Final.xlsx

[suzib6sw]

Dell 7300/7400 share the same bios. change relevance to include Latitude 7400