Is it posiible to do some bulk maintenance to spiceworks tables using the SQLite ODBC driver or a more complete driver? I realise that there are dangers with databse corruption, but this would be very useful?

Or is it possible to do bulk maintenance (not import) to fields another way?

It is possible to make edits and extract data for detailed (non-Spiceworks) reporting using SQLite ODBC and many of us do this using a variety of thrid party tools.

As for write access to the db, two significant conditions need to be met, firstly the db should not be in use by Spiceworks, Spiceworks should be stopped while writing to the db, secondly if using Vista or Windows 7 the tool you are using to modify the db should be 'Run as Administrator' to ensure write access to the db.

Of course always best to backup Spiceworks before making external edits to the db for safety and recovery purposes should anything go wrong.

4 Replies

It is possible to make edits and extract data for detailed (non-Spiceworks) reporting using SQLite ODBC and many of us do this using a variety of thrid party tools.

As for write access to the db, two significant conditions need to be met, firstly the db should not be in use by Spiceworks, Spiceworks should be stopped while writing to the db, secondly if using Vista or Windows 7 the tool you are using to modify the db should be 'Run as Administrator' to ensure write access to the db.

Of course always best to backup Spiceworks before making external edits to the db for safety and recovery purposes should anything go wrong.

The other thing I should have mentioned is that the Spiceworks database usage is not in some cases obviously relational, but programatic relationships exist with lots of tables and fields, so if planning to modify data ensure you understand the schema and that you take account of any programatic relationships in the data to avoid breaking Spiceworks.