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.
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 aaauser.user_id "userid",aaauser.first_name AS "name",AaaLogin.DOMAINNAME "domain" FROM PortalUsersLEFT JOIN SDUser sduser ON portalusers.USERID=sduser.USERIDleft join aaauser on sduser.userid=aaauser.user_idLEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_IDLEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_IDLEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_IDwhere sduser.status='ACTIVE' and portalusers.userid not in (select userid from portaltechnicians) andAaaLogin.DOMAINNAME = 'sdptest'
- Assumptions:
- Domain is "sdptest"
- Also, please maintain the same names for the columns(userid, name, domain) 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_sdp_user_csv.py <report_filename>.csv