Service Desk Practitioners Forum
cancel

Service Pages Accounts

Highlighted
Elias Abboud
Acclaimed Contributor.

Service Pages Accounts

Hello everyone,

1. In which database table are the service pages accounts stored? is it in rep_accounts?

Can anyone suggest an SQL query that would return the account login names?

Could it be possible to create the sp accounts by directly inserting data to this table using an SQL insert query? if yes is this table linked to other tables that i might need to insert data to it too?

Thanks in advance for any help
If you can't solve it, post it :)
3 REPLIES
Gyula Matics_1
Acclaimed Contributor.

Re: Service Pages Accounts

To list service pages accounts:

select acc_loginname
from rep_accounts
where acc_subtype='281481481158664'

As for creating accounts directly, you'd rather use data exchange. But if you really want to do it, you need to insert two records, one in rep_accounts, and another in rep_roles_per_account (to link to the service pages role)

Gyula
Radovan Skolnik
Acclaimed Contributor.

Re: Service Pages Accounts

Elias, if you do not want to endanger your SD intsallation I would not try to insert data directly. SD uses some sofisticated mechanism to generate unique OIDs for objects and by adding records manually you may break this (i.e. SD will create object with the same OID for example that would lead to database inconsistency).
Ramaprasad N
Outstanding Contributor.

Re: Service Pages Accounts

Yeah. However, you may try to use Web-APIs