Query to get Cab, Cab Members along with their email address (MSSQL)

Query to get Cab, Cab Members along with their email address (MSSQL)

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 to get technician details(domain, associated account, email) from builds (MSSQL & PGSQL)

                      Tested in builds from PGSQL (14300) or MSSQL (14306) SELECT aau.first_name "First Name", sdu.lastname "Last Name", AaaContactInfo.EMAILID "Email Address", sdo.name "Associated Sites", adef.org_name "Associated Accounts", df.domainname "Domain Name" ...
                    • 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 ...