Creating a database with HWiNFO reports

[Chiyawa]

Hi,

 

I'm looking a way to create a database of our systems. I think I'll be using Microsoft Access or Open Office Base.

 

HWiNFO actually list all the hardware information of the system, which I like to include some of its list into the database.

 

So, the database needs to include like The system name, the service tag or serial number, and a summary of the component that they have (such as CPU, GPU, HDD or storage). There will be some data that I have to manually put into it, such as the current 'owner', date assigned and so on.

 

The thing is now how to integrate the reports generated by HWiNFO into the database without having to input manually?

 

Regards,

Chiyawa

[Electronics Wizardy]

Wanna be really lazy, just use a inventory tool like lansweeper and it will do basically all of this for you, and you get a lot of other cool info too.

 

Otherwise, just get a export of that data, or use something like dxdiag built in(might want a script), then make anouther script to put in in the db.

 

If you don't have a lot of systems, excel and doing it manually will be a lot faster.

[Chiyawa]

2 minutes ago, Electronics Wizardy said:

Wanna be really lazy, just use a inventory tool like lansweeper and it will do basically all of this for you, and you get a lot of other cool info too.

 

Otherwise, just get a export of that data, or use something like dxdiag built in(might want a script), then make anouther script to put in in the db.

 

If you don't have a lot of systems, excel and doing it manually will be a lot faster.

I see. Thanks for your suggestion.

[Chiyawa]

2 hours ago, Sakuriru said:

Very easy -- get a developer to write a script.

 

What OS are these running, and how are you generating the reports from HWiNFO?

The OS is Windows 10 Pro, and generating report is done through the export button from HWiNFO software of the clients PC. The report can be in CSV or HTML format.

[Alexeygridnev1993]

On 11/23/2020 at 4:14 AM, Chiyawa said:

Hi,

 

I'm looking a way to create a database of our systems. I think I'll be using Microsoft Access or Open Office Base.

 

HWiNFO actually list all the hardware information of the system, which I like to include some of its list into the database.

 

So, the database needs to include like The system name, the service tag or serial number, and a summary of the component that they have (such as CPU, GPU, HDD or storage). There will be some data that I have to manually put into it, such as the current 'owner', date assigned and so on.

 

The thing is now how to integrate the reports generated by HWiNFO into the database without having to input manually?

 

Regards,

Chiyawa

Well, you'll obviously need someone with a little bit of programming knowledge. But you can use Python "pyodbc" module to connect to MS Access database and then write a function to insert the contents of your .csv file into the database - and all that in something like 20 lines of code.

[Chiyawa]

1 hour ago, Alexeygridnev1993 said:

Well, you'll obviously need someone with a little bit of programming knowledge. But you can use Python "pyodbc" module to connect to MS Access database and then write a function to insert the contents of your .csv file into the database - and all that in something like 20 lines of code.

I see. Okay, will check it up.