How do I automatically import the data to SQL Server?

[Nish]

Install the MSSQL client software onto the systemhound central server.

Create a .bat file to run the shexport tool from the command line. The parameters required can be found in the systemhound User Guide. Or see this thread:

http://www.systemhound.net/community/index.php/topic,110.0.html
[ v4 update: http://www.systemhound.net/community/index.php/topic,215.0.html ]

Create a .bat file to run bcp (SQLServer's Bulk Copy utility) to load the exported file into the database. For this to work you will need to create the tables within a SQL database beforehand, and produce a .fmt file to describe the columns in each table. The required arguments for bcp can be found by running bcp /?

It may be best to create a single .bat file to run both the shexport and bcp jobs, and use the Windows scheduler to run them.

[Cardio]

I downloaded the trial version to see how it works and it seems to store the acquired data from the clients in javascript files..

Is there a way this product can be installed so that the repository of the client data is a SQL Server database?

We want to do our own reporting on config data - not go via a web-site

tia

[Nish]

systemhound does not store its data in SQL Server (although the Enterprise version currently in development will do that).

We provide two export options: CSV or Access. Export the data in this way and then import it into your SQL Server db.