Bulk Request Delete 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: <sdp_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",wo.helpdeskid "portalid" FROM WorkOrder woLEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERIDLEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_IDWHERE (wo.ISPARENT='1') and wo.title = 'Cryptocurrency wallet software started'
- Assumptions:
- Subject is "Cryptocurrency wallet software started"
- Also, please maintain the same names for the columns(workorderid, portalid) as they are used within the script.
- 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 delete_request_csv.py <report_filename>.csv