Bulk request edit via python script invoked from command prompt
Please refer to the below link to install and configure python on the server.
Steps for configuring the script:
- Extract the zip in a particular location, eg: <SupportCenterPlus_home>\integration\custom_scripts
- Update the app url and technician_key in the script.
- Follow this link to create integration key: https://pitstop.manageengine.com/portal/en/kb/articles/creating-integration-key
- Create a Query Report with the below query and save it with a name.
- SELECT wo.WORKORDERID AS "workorderid" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE ( ( ( ( wo.CREATEDTIME < 1689791400000 ) AND ( ( ( wo.CREATEDTIME != 0 ) AND ( wo.CREATEDTIME IS NOT NULL ) ) AND ( wo.CREATEDTIME != -1 ) ) ) AND ( qd.QUEUENAME = 'Cash Desk' ) ) AND ( std.STATUSNAME = 'Closed Quote request' ) ) AND wo.ISPARENT='1'
- Please update the above as per your instance in the query and export the report as a csv file.
- Save the exported file in the same location as the python file.
- Open command prompt with administrator permission and invoke the below command. CMD: py update_requests_csv.py <report_filename>.csv
New to ADSelfService Plus?
Related Articles
Update status using Python script in 11.0
Using a Python script via custom trigger, we can update the status invoking an API call. A short guide on setting up python is available here : https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server Find the attached ...How to setup Python on the Server
This article explains how to set up the ServiceDesk plus server to run python scripts. 1. The first step is to install python on the application server and you can download it from here. Any version above 3.4.1 should work fine. Start the setup and ...Script to Auto close Request when the status is Resolved for a particular number of days
For version 11 and above: -> In version 11, we only have the option to set the request Auto-close for a max of 10 days -> The below script will help you to extend the auto-closure time Execution steps: 1. Go to Reports--> New Query Report and run the ...Script to satisfy first response SLA in SCP 11
As of now only for the following scenarios, First response can be marked in the SupportCenter application: * Notes addition * Worklog addition * Technicians manual response Apart from this if you want to mark any other actions in the application as ...Phone number need to be mandatory in 8.1 for contacts
Kindly follow the steps below to create the FAFR, 1. Access admin Module 2. Select the request template option and click the edit option the required request template the script needs to be applied on 3. Select the Fields and Forms Rule tab and paste ...