Hi,

We have a query that identifies all employees that are not service request approvers that also have a custom attribute (people.ATTRIBUTE_176) value of 4 or greater.

What we need now is to change the settings for the employees returned in this query to be service request approvers and be able to view all requests.

Report Query:

SELECT  AaaUser.FIRST_NAME "FullName" ,people.ATTRIBUTE_176 "Org Level",AaaUser.user_id, JOBTITLE "JobTitle" , SDUser.USERID FROM AaaUser
INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID
left join people on sduser.ciid=people.ciid
left join SRApproverDetails srad on srad.approver=AaaUser.user_id
LEFT JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID WHERE  ((HelpDeskCrew.TECHNICIANID IS NULL) AND (SDUser.STATUS = 'ACTIVE')) and srad.approverstatus is null and people.ATTRIBUTE_176 >'4'

-------------------

Thanks in advance

Dave