ocsweb DB data table Query and export

Question

Dear Support,

We want to export the Model，Serial number and BIOS Date of manufacture of the relevant equipment from ocsweb DB to our information system for asset analysis. After querying the table, we can't find the result. so we need your help.

OS：Centos 7(CentOS Linux release 7.9.2009)

Database Server：MariaDB Server version 10.3.30

OCSReports Version：OCSNG_ UNIX_ SERVER-2.9+Agent-2.8.0.0

Web Server：Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 mod_perl/2.0.11 Perl/v5.16.3

What should I do?

Thanks & Best regards,

awenon

Answer 1

Hi,

Bios date is in bios table. What model and serial number you want ?

Best regards

Frank