Crystal Report from Citrix DB

[Amphrodite1]

i want to create report of the citrix db (SQL) using crystal report to get the users list with the assaigned applications. But when i select the db it is showing some
encrypted things. Can you explain me how we can create the report from citrix DB.

 

[digimahn]

Amphrodite1,

I don't think you want to be messing with your IMA with Crystal...

Taken from:

http://support.citrix.com/servlet/K...-7770/Feature_Release_2_Advanced_Concepts.pdf

Chapter 3, Page 19
With the exception of indexes, all information in the data store is in binary format. This is why it looks encrypted to you
Meaningful queries cannot be executed directly against the data store. Neither Citrix administrators nor users should directly query or change information in the data store. Use only IMA-based tools, such as the Citrix Management Console, to access the information in the data store.

CAUTION Do not directly edit any data in the data store database with IBM DB2, Microsoft SQL Server, or Oracle tools. Doing so corrupts the farm database and causes the farm to become unstable or completely unusable.


With that said, if you could not determine that the IMA is pretty much all binary on your own, I don't think you should be messing with it on a production server. Now a test bed is a different story! Querry away to your heart's content, but you will have to figure out how to convert MS SQL Binary to text values. It can be done though and you are on the right track. I am sorry I don't have any more "detailed" help for you, but this should get you moving in the right direction

DigiMahn