Inspecting the Spiceworks Database

Recently I’ve had to write some custom queries to get data out of the Spiceworks database. I’ve found that the easiest way to do it is as follows:

  1. Open SQLite Studio (download it here)
  2. Grab a copy of the Spiceworks database, spiceworks_prod.db. It usually lives in C:Program Files (x86)Spiceworksdb on the machine running Spiceworks. The good thing is that this can be done without stopping the Spiceworks service.
  3. Add the database in SQLite, leaving all other options at their defaults, then click OK
    Screen capture of the add database screen in SQLite showing the Spiceworks DB connectioni details
  4. Right-click on the database, and click Connect

You’ll then be able to view the tables and browse their data. If I’m scripting something, I always compose and test the SQL queries here first before moving them across into my scripts.

Screen capture of tickets table contents from the spiceworks database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s