Set the line manager of a change based on the change requesters or the implementers reporting-to.

Set the line manager of a change based on the change requesters or the implementers reporting-to.

Note:  Attached script will not work beyond 11138 SDP Version.

We can use custom schedule to achieve this requirement.

Step 1: we have to run the below query in query report and save the report.

select userid,reportingto from sduser where status='ACTIVE'  and reportingto is not null

Configure the saved report in custom schedules.



Step 2:  Configure the set linemanager script in admin-> change custom scripts.




                    New to ADSelfService Plus?

                      • Related Articles

                      • Dynamically set ChangeRequester's reporting to user as the Line Manager

                        Requirement: Change Requester's Reporting manager has to be set as the Line Manager. Steps to configure: 1.  Download the attached scripts.  Copy the contents into Change custom functions. 2.  Goto Admin > Change Custom Function > Global Function > ...
                      • Set Change Requester's reporting_to user as Change Approver

                        Requirement: When a Change Request is submitted, Change requester's reporting to manager has to be set as Change Approver. Steps to follow: Goto Admin > Developer Space > Global function > New > Paste the content from the attachment  ...
                      • How to automatically assign users to different roles in a change request.

                        This script is applicable only for builds prior to 11138. This is a sample python script to read the value in the Change Owner field, when a Change Request is created and set him/her as the Change Implementer automatically, using Change Custom ...
                      • Change roles

                        SELECT chdt.changeid               "Change ID",         chdt.title                  "Title",         orgaaa.first_name           "Change Requester",         ownaaa.first_name           "Change Owner",  ...
                      • Dynamically set SLA based on field values

                        Requirement: SLA for service requests needs to be set depending on the category, subcategory and priority of the request. Usecase: The possibility to modify/set SLA depending on a request Field is not available in Service Request. Also, since SLA is ...