Report on Organizational roles
DB Compatibility : PGSQL & MSSQL
Build Compatibility : Builds above 10000
select r.orgrolename "orgrolename",
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
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 ...
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 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 Triggers. This is achieved by submitting an update request to ...
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 ...