[RESOLVED] BIOS List

[Mathieu]

- WAPT 1.7.4.6143 Enterprise
- Debian 9.9

Hello,

We created a query to display BIOS versions by PC model,

but we're having a problem. I saw a computer with BIOS version A00. I checked on that computer, and the BIOS version is A23. No matter how many times I refresh the information, the BIOS version doesn't change in WAPT.

How does the hardware inventory scan work in WAPT? What is the scan frequency based on?

I checked in GLPI, and the BIOS is correctly reported as A23.

So, my query could be full of errors if the information is incorrect.

In my query, I'm using the SMBIOS property. Regarding

the modification on 11/10,
I saw the "Refresh computer inventory" button, so the information is correctly displayed.

[sfonteneau]

Hello Mathieu

By default, the wmi inventory is actually done only once.

We don't do it every time because doing a WMI inventory is very computationally expensive for the agent.

So indeed, if there are changes on the machine and you want to update the inventory, you have to do a new register.

You can, if you want, create a package that performs an audit like this:

Code: Select all

def audit():
    WAPT.register_computer()

And you define how often you want to force the inventory update using audit_schedule in the control file

[Mathieu]

THANKS

It works perfectly.

For those who might be interested, it's not perfect, but it works

Code: Select all

select
count(distinct computer_name) as NbMachines,
productname as MODELE,
wmi->'Win32_BIOS'->>'SMBIOSBIOSVersion' as Bios_Version ,
string_agg(distinct lower(computer_name),' ') as Computer_name
from hosts
group by productname, wmi->'Win32_BIOS'->>'SMBIOSBIOSVersion'