Thycotic Community - Secret Server - Custom Report Query - Messages

Message from Jonathan

Fri, 07 Oct 2011 15:28:22 GMT

Yes, that should work. There are several webservice examples in the KB.
http://support.thycotic.com/KB/search.aspx

Let us know if you need help.

:-D

Message from Gary J

Thu, 06 Oct 2011 23:17:50 GMT

Thanks Jonathan. We're looking in to using Web Services to see if we can retrieve the data using that method.

I'll let you know if we get stuck at all.

Cheers
Gary

Message from Jonathan

Thu, 06 Oct 2011 21:26:01 GMT

Gary,

The reports in Secret Server are created using regular SQL (in the Enterprise Edition you can create your own reports by typing in the SQL through the UI, choosing your chart type, etc. - you can also request tech support to write the SQL and then just add it to your Secret Server).

In the Secret Server database, all the secret data is encrypted for security reasons, the audit data is not encrypted. So reports are typically against the audit data. You would not be able to create a useful report in Enterprise Edition that pulled back secret data as it would be displayed on the report in encrypted form.

Would love to talk more about your needs as there may be another solution. Want to take this offline and chat by phone?

Message from Gary J

Thu, 06 Oct 2011 18:41:54 GMT

Hi Tucker

I think you misunderstood. I don't want to write a custom SQL report with SQL Reporting Services. I was under the impression that with Secret Server Enterprise Edition you were able to create your own reports. My question is whether the type of report I am after could be accomplished with the functionality within Secret Server Enterprise Edition or not.

I hope this clarifies what I'm after.

Cheers
Gary

Message from Tucker

Thu, 06 Oct 2011 08:25:41 GMT

Hello Gary,

The Secret Item data is encrypted in the database, so you cannot query it with SQL reports. There is a way to disable encryption for those fields but it is not recommended for security reasons and would require re-entering / converting your existing data.

Message from Gary J

Thu, 06 Oct 2011 02:52:14 GMT

Hi

With the custom reports in Enterprise Edition, would it be possible to create a report that essentially displays all fields for all secrets the current user has access to, except for the password field? It will more than likely need to be restricted to displaying one secret type at a time to cater for field differences between secret types.

We currently don't have Enterprise Edition so can't test out the custom reports. If it comes to it I'll organise a trial version to test but thought I would post here first to see if anyone knew.

Cheers
Gary