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 ...