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
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
New to ADSelfService Plus?
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 ...Unauthorized Access CSV Report for Users Not Present in the Application
Report Details: Currently, the application has not been recording data regarding login attempts when the username used is not available in the application. This report will store the login attempts with usernames who do not exist in the application. ...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 ...