Service Desk Practitioners Forum
cancel

Reports

Highlighted
Veronica_13
Trusted Contributor.

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
Acclaimed Contributor.

Re: Reports

Hi Veronica,

What version of SD are you using 4.5 or 5?

Regards

Ruth
http://www.teamultra.net
Vasily Kamenev
Acclaimed 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
Acclaimed 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
Super Contributor.

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