Script to mark all private notes as public

Script to mark all private notes as public

Use case:
Once a request is resolved all the private notes should be made public (requester shall view).

Prerequisites:
2. functions.py :  This package consists of all the functions that are used to handle the standard requirements of the customer.  Most repeated requirements are written as separate functions.  Depending on our usecase, we can include these functions in our script. 
3. configuration.json : This file maintains the configuration details of the installed server.  

Execution steps:    
1.  Extract the ZIP file under ..\ManageEngine\Servicedesk\integration\custom_scripts - folder.
2.  Edit the configuration.json and update the values.
3.  This Script can be configured as a custom trigger, which would get invoked right-away when a condition is met or you can configure the same script as a request custom menu, which would get invoked only when you invoke the menu manually from the Request Details Page. This is something that needs to be set depending on your requirement.
4.  For Custom Triggers:  Go to Admin > Custom Trigger > give a trigger name > execute script > py mark_notes_public.py $COMPLETE_V3_JSON_FILE and set the criteria as "Impact=High"
5.  For Request Custom Menu: Go to Admin > Request Custom Menu > give a menu name > Action Type : execute script > py mark_notes_public.py $COMPLETE_V3_JSON_FILE. Invoke this script from Request Details page > Actions > Menu Name.

          • Related Articles

          • How Public and Private solutions work?

            ServiceDesk Plus allows you to publish knowledge base solutions as either public (available for all requesters and technicians) or private (accessible only by technicians). To make a solution public, while adding/editing the solution select the ...
          • Report on Notes

            This report gives an overview of all Notes added by the Technician. This report helps to find a specific word in the Notes, specific technician name etc..  To make any changes to a query, refer to the KB article below. ...
          • Problem Notes

            SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", ownaaa.FIRST_NAME "Technician", longtodate(prob.REPORTEDTIME) "Reported Date", sdno.description "Notes" FROM Problem prob LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ...
          • Create multiple Child Requests - Deluge Script

            This is a sample deluge script to automatically trigger the creation of multiple child requests from a parent request, based on the request template chosen. The request ID of the child requests will be added as a Note in the parent request. This is ...
          • Script to set Request Technician as the Task Owner for all associated tasks - Deluge

            Requirement:  Request technician should be set as the task owner for all available tasks. Use case: When the request is updated with the technician, all the associated task needs to be assigned to the same technician. Python ...