Service Desk Practitioners Forum
cancel

Create SP Account from a Change Ticket

Highlighted
Harini.G
Honored Contributor.

Create SP Account from a Change Ticket

Hi All,

Is there a way to open the SP Account form from a change ticket using sd_dataform or anyother tool?

Pls help..

Rgds
Harini.G
3 REPLIES
Akies
Outstanding Contributor.

Re: Create SP Account from a Change Ticket

Hi Harini,

Not sure but you can create a batch file in which you can call the database and use INSERT query into REP_ACCOUNTS table. Use that file through UI rule using smart actions.

This will help you in going further.

Hope this helps.

Regards,
Akhil
Harini.G
Honored Contributor.

Re: Create SP Account from a Change Ticket

Hi Akhil,

Sorry to tell you that I am a learner... can u pls help me with the script in case its no problem to you.

Rgds
Harini.G
Akies
Outstanding Contributor.

Re: Create SP Account from a Change Ticket

Hi Harini,

Write a batch file and put following data:

cd c:
sqlplus XXX/ZZZ@YYY < ABC.sql

where XXX is the username
ZZZ is password and
YYY is the database name

also create a ABC.sql file in which write INSERT query as explained you earlier.

Hope this helps you.

Regards,
Akhil