Report on Organizational roles

Report on Organizational roles

DB Compatibility : PGSQL & MSSQL

Build Compatibility : Builds above 10000

select  r.orgrolename "orgrolename",
r.description "Description",
au.FIRST_NAME "Name",
DepartmentDefinition.DEPTNAME "Department",
SDOrganization.NAME "Site"  from aaauser au
left join (select roleid,userid From roletousermapping rm group by roleid,userid) rm on au.user_id = rm.userid
left join orgroles r on rm.roleid = r.orgroleid
LEFT JOIN UserDepartment ON au.USER_ID=UserDepartment.USERID
LEFT JOIN DepartmentDefinition ON UserDepartment.DEPTID=DepartmentDefinition.DEPTID
LEFT JOIN SiteDefinition ON DepartmentDefinition.SITEID=SiteDefinition.SITEID
LEFT JOIN SDOrganization ON SiteDefinition.SITEID=SDOrganization.ORG_ID
where r.orgrolename is not null
order by 1,2

          • Related Articles

          • Technician Roles

            This report is used to get the roles of the technicians. For version 10.5 and below SELECT au.FIRST_NAME "Technician", (ar.NAME) "Role" FROM HelpdeskCrew hdc LEFT JOIN SDUser sd ON hdc.TECHNICIANID=sd.USERID LEFT JOIN AaaLogin al ON ...
          • Software Compliance Report

            Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...
          • Change roles

            SELECT chdt.changeid               "Change ID",         chdt.title                  "Title",         orgaaa.first_name           "Change Requester",         ownaaa.first_name           "Change Owner",  ...
          • 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 ...
          • Update Change Roles using Change Custom Function

            This is a sample Deluge script to set Line Manger field. When a Change Request is created, ChangeRequester's reporting_to user is set as the Line Manager automatically, using Change Custom Triggers. This is achieved by submitting a update request to ...