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

Create SP Account from a Change Ticket

Highlighted
Harini.G
Collector

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
Occasional Visitor

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
Collector

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
Occasional Visitor

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
//Add this to "OnDomLoad" event