Bulk Request Delete via python script invoked from command prompt

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:
  1. Extract the zip in a particular location, eg:  <sdp_home>\integration\custom_scripts
  2. Update the app url and technician_key in the script.

  4. Follow this link to create integration key: https://pitstop.manageengine.com/portal/en/kb/articles/creating-integration-key
  5. Create a Query Report with the below query and save it with a name.
    1. SELECT wo.WORKORDERID AS "workorderid",wo.helpdeskid "portalid" FROM WorkOrder wo 
      LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 
      LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
      WHERE (wo.ISPARENT='1') and wo.title = 'Cryptocurrency wallet software started'
    2. Assumptions: 
      1. Subject is "Cryptocurrency wallet software started"
      2. Also, please maintain the same names for the columns(workorderid, portalid) as they are used within the script.
    3. Please update the above as per your instance in the query and export the report as a csv file.
    4. Save the exported file in the same location as the python file. 
  6. Open command prompt with administrator permission and invoke the below command. CMD: py delete_request_csv.py <report_filename>.csv
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • 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 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:  ...

                      • Collecting Environmental Variables Relating to Python in Linux/Windows/MacOSX

                        When setting up a python script in the customer's end, a major challenge is relating to the following: Is Python installed or not? If installed, are the required modules installed or not? Answering the above will help us in overcoming the doubt of ...

                      • 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. Once you've ...

                      • Bulk close Purchase Orders - Python

                        Requirement: Delete older Purchase Orders. UseCase: Closing Purchase Orders from a external CSV. Please follow the below steps. Extract the attached scripts in a folder. Update the URL and integration key in the script. You can get the integration ...

                        Related Products