Thycotic Community Forum

10/6/2011 2:52:14 AM Gary J Posts: 10	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
	0 • link
10/6/2011 8:25:41 AM Tucker Posts: 87	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. -- Regards, Tucker
	0 • link
10/6/2011 6:41:54 PM Gary J Posts: 10	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
	0 • link
10/6/2011 9:26:01 PM Jonathan Administrator Posts: 591	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? -- Secret Server 8.1 - Web Password Filler, SAP support, advanced discovery capabilities with rules. Need a free trial license?  Send an email to sales@thycotic.com
	0 • link
10/6/2011 11:17:50 PM Gary J Posts: 10	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
	0 • link
10/7/2011 3:28:22 PM Jonathan Administrator Posts: 591	Yes, that should work. There are several webservice examples in the KB. <a href="http://support.thycotic.com/KB/search.aspx">http://support.thycotic.com/KB/search.aspx</a> Let us know if you need help. :-D -- Secret Server 8.1 - Web Password Filler, SAP support, advanced discovery capabilities with rules. Need a free trial license?  Send an email to sales@thycotic.com
	0 • link

---