Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Reports

Highlighted
Veronica_13
Super Collector

Reports

I am trying to create a report where it shows all the Accounts that are associated to the specific Security access role. Also what are the include roles for the respective role.
I have been looking at the database, can't find any table that has role in it.
Thanks.
4 REPLIES
Ruth Porter
Honored Contributor

Re: Reports

Hi Veronica,

What version of SD are you using 4.5 or 5?

Regards

Ruth
http://www.teamultra.net
Vasily Kamenev
Honored Contributor

Re: Reports

HI Veronica.
Are you like create report(describe the where Crystal Report or other system) or special view in Administration console for managing Accounts.

Vassili
Ruth Porter
Honored Contributor

Re: Reports

Hi Veronica,

The tables for roles seem to be in version 5: rep_roles, rep_roles_include, rep_roles_per_account
and in 4.5 they are the same but in uper case.

Hope this helps

Ruth
http://www.teamultra.net
Dwayne A
Member

Re: Reports

Veronica,

If it's an Oracle database, it might have been created with two useer. One for data and one for resporitory

Dwayne
//Add this to "OnDomLoad" event