Hi, currently evaluating VisualCron for automating some IT related processes...

One thing i noticed, is that the log are conveniently stored in an SQL Server compact database. Great! For advanced diagnostic when we run into problems, the UI can be a little limiting, so I'm thinking "No problem, I'll just go straight in the database".

Oh whoops, its password protected :) And I don't see the password in any config file or anything.

We have password protected the file because some users find the output information (which is stored in database) sensitive.

The best way to access the database is through the VisualCron API. With a few lines you can logon to the VisualCron Server and then access the database. You could then, if you want to, create a simple script that extracts the data that is relevant and insert into your own database.

I am not a programmer and have no idea how to use the API..is there anyway the password can be given to access the SQL Server Compact Editon database so i can look at logs?

The main reason that we do not give the password is that we then bypass VisualCron security. The only way to access the database is when you have already logged on VisualCron - through client or API. Then we can give the information as the data itself may contain confidential output.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.