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.

Is it possible to get access to that database?

Thanks!

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.

Please let us know if you need any help.

---

Yeah that would be an acceptable workaround.

Though is there something special to do to access the logs from the API? I just tried the following code:



And it returns nothing. Note that Ive been playing with other parts of the API in the same application to get jobs, tasks, etc and that all work, so I assume my connection is done correctly?

Thanks!

This is VB.NET but probably can convert it:

' get a list of historic results
Dim jl As List(Of LogTaskHistoryClass) = ConnectionAPI.CurrentServer.Log.GetTaskHistory(TaskId, thisMorning, Now)

Use the "ExecutionId" property to retrieve the specific output:

Private Function GetOutput(ByVal executionId As Guid, ByVal bolStandardOutput As Boolean) As String
If Not dicOutput.ContainsKey(executionId) Then
Dim ltoc As LogTaskOutputClass = ConnectionAPI.CurrentServer.Log.GetTaskOutput(executionId)

dicOutput.Add(executionId, ltoc)
End If

If bolStandardOutput Then
Return dicOutput(executionId).StandardOutput
Else
Return dicOutput(executionId).StandardError
End If
End Function

---

There we go, that worked :)

Thanks!

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?

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?

I don't think the password will be given. And if support will give it to you it wil not be on the forum.
The golden rule for a password is to keep it hidden 😎.

Regards
Erik

---

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.

---