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
Bulk request edit via python script invoked from command prompt
Please refer to the below link to install and configure python on the server. https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server/ Steps for configuring the script: Extract the zip in a particular location, eg: ...Bulk Request Delete via python script invoked from command prompt
Please refer to the below link to install and configure python on the server. https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server/ Steps for configuring the script: Extract the zip in a particular location, eg: ...Request add attachment_Python script-API
Steps for adding attachment to the request through python script-API. Extract the attached "Attachment_Python_Script.zip" >> Edit attachmentscript.py >>Mention product installed url in the base url ; update the api key; update the request id that ...Bulk User Delete based on Domain via python script invoked from command prompt
Please refer to the below link to install and configure python on the server. https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server/ Steps for configuring the script: Extract the zip in a particular location, eg: ...Create New request using Python Script
Script to raise a new request using Python Script. Pre-requisite - Python should be installed in the server and configured. You can review the instructions here - Requests module should be installed with the python Steps 1. Download the zip file from ...