Query to get Cab, Cab Members along with their email address (MSSQL)
![](https://static.zohocdn.com/zoho-desk-editor/static/images/file.png)
Tested in build MSSQL (14306)
MS-SQL
select cab.name as "CAB Name", usr.first_name "CAB Member",AaaContactInfo.EMAILID AS'Email' from cabdefinition cab left join cabmembers members on cab.cabid = members.cabid left join aaauser usr on members.userid = usr.user_id LEFT JOIN AaaUserContactInfo ON usr.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID order by 1;
New to ADSelfService Plus?
Related Articles
How to assign CAB members to a change request automatically.
Note: Attached script will not work beyond 11138 SDP Version. This is a sample script to add CAB Members to a Change Request through Change Custom Triggers.The CAB Members can only be added manually to the Change Request ,under the Approval Tab, ...
Cab
SELECT changetocab.changeid "ChangeID", chdt.title AS "Title", ctdef.NAME AS "Change Type", ownaaa.first_name AS "Change Owner", ...
Query report to get requestid,username ,email with created date ( MSSQL )
Tested in build MSSQL (14306) SELECT wo.WORKORDERID AS "Request ID", aaau.FIRST_NAME AS "Requester", aaaci.emailid,wo."TITLE" AS "Subject", "cd"."CATEGORYNAME" AS "Category", longtodate(wo.CREATEDTIME) AS "created time" FROM "WorkOrder" "wo" Left ...
FAFR script to validate email address
Script var field = "WorkOrder_Fields_UDF_CHAR1"; var emailID = $CS.getValue(field); if (!ValidateEmail(emailID)) { alert('Please enter a valid email address example@abc.com'); $CS.stopFormSubmission(); } /*A function which takes email and validate ...
Query to show request details along with technician's and requester's department (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Along with technician's department: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", qd.QUEUENAME AS ...