The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Relate SP account to users

Highlighted
Akies
Occasional Visitor

Relate SP account to users

Hi,

I want to execute a query by which I can relate my person's account with the existing SP account having loginname same as searchcode of that person.
Also I want to execute the same for person's whose accoutn is empty.

Can anyone help me on the same please?

I am using below query in the database but no result on service desk:

UPDATE ITSM_PERSONS SET PER_ACC_OID = (SELECT ACC_OID FROM REP_ACCOUNTS WHERE (ACC_LOGINNAME = PER_SEARCHCODE) AND (ACC_CONCURRENTUSER = 0) AND (ACC_INTEGRATIONSACCOUNT = 0) AND (ACC_NAMEDUSER = 1) AND (ACC_PASSWORD = 'FI3njP9Iv5TLds/d/vl/BA==')) WHERE (PER_ACC_OID IS NULL)

Am I wrong in this?

Regards,
Akhil
1 REPLY
Akies
Occasional Visitor

Re: Relate SP account to users

Hi All,

I got the desired result from above query itself.

However just for securty purpose, I want to know whether the same is right or not before getting this done on my production machine.

Regards,
Akhil
//Add this to "OnDomLoad" event