SIW Support Forum - 3rd party solutions

siw2odbc and sensor data

Wed, 04 Jun 2025 20:15:34 +0000

I've used siw2odbc to dump my xml reports into MariaDB. It appears that there's a table missing for sensor data. The siw_Sensors table has one record for each computer, and the siw_Sensors_Props table has one record for each category of sensors (motherboard, video card, network adapter, etc.) on each computer. The siw_Sensors_Details table has one record for each type of measurement (voltage, rpm, power, etc.) for each category on each computer. But the individual sensor readings don't exist in the database, even though i can see them in the XML.

It appears that the XML has an extra level of computername" > at the beginning of the sensors page. I'm using SIW 2025 v15.4.0503c 64-bit Technician's Version.

Am I missing something, or is this a bug?

siw2odbc questions

Sat, 11 Nov 2017 07:18:21 +0000

The mere fact this tool exists is great... but I have a couple questions/wish list since I can't seem to find an answer...

1. Is there any way to import multiple xml files at once - for example: siw2odbc *.xml
2. The tool seems to UPDATE records for existing computer names - is there any way to NOT update but add multiple? This is potentially problematic as I could have two computers with the same name at two sites and now it overwrites one with another. Similarly, I might like to see a history of changes and be able to search through the database, comparing a computer's config from one date to another. Perhaps a command line switch that says what to do - update or add?
3. is there any public documentation available for this (or am I blind? I could be... it's happened before).

siw2odbc

Sun, 15 Oct 2017 18:29:14 +0000

Andrei Topala wrote siw2odbc. Please check https://www.gtopala.com/siw-report/reports.php

Analyzing multiple reports - using XML output

Mon, 10 Dec 2012 19:05:22 +0000

I am a volunteer with a small charity. We have several offices, each with just one or two PCs. I would like to run SIW on each machine and then import the data (via XML?) into a datatbase (mySQL??) for further analysis.

Has anyone have any thoughts on how this could be achieved?
Is there perhaps some third party product that already does this?

Cheers
Geoff

SIW Viewer

Tue, 07 Feb 2012 14:01:31 +0000

Used to show XML Reports created by SIW
C# source code available on github
More info here.