Differences

This shows you the differences between two versions of the page.

--- transform_scripts [12/30/2024 06:52] – created johnsonjohn
+++ transform_scripts [12/30/2024 06:54] (current) – johnsonjohn
@@ Line 26: / Line 26: @@
 </code>
 -----
+====Example====
+<code>
+(function transformRow(source, target, map, log, isUpdate) {
+    //Set Last Refreshed On Date to Help Mark Active Groups
+    target.u_last_refreshed_on = gs.nowDateTime();
+    target.u_active = true;
+    //Convert source timestamp to GlideDateTime
+    target.u_group_created = new ymdLDAP().convertFrom(source.u_whencreated);
+    target.u_group_changed = new ymdLDAP().convertFrom(source.u_whenchanged);
+    //Check if the group is distribution or security
+    var regexDist = new RegExp(/\b(OU=Distribution,OU=Groups)\b/gi);
+    var regexSNow = new RegExp(/\b(OU=ServiceNow,OU=Groups)\b/gi);
+    var regexGal = new RegExp(/\b(OU=GalSync,DC=Universal)\b/gi);
+    var regexSec1 = new RegExp(/\b(OU=Security,OU=Groups)\b/gi);
+    var regexSec2 = new RegExp(/\b(OU=SecurityGroups,DC=Universal)\b/gi);
+    var regexSec3 = new RegExp(/\b(OU=Security Groups)\b/gi);
+    var regexAdmin1 = new RegExp(/\b(OU=Microsoft Exchange Security Groups)\b/gi);
+    var regexAdmin2 = new RegExp(/\b(OU=Administration)\b/gi);
+    var regexAdmin3 = new RegExp(/\b(CN=Builtin)\b/gi);
+    if (regexDist.test(source.u_distinguishedname)) {
+        target.u_group_type = 'distribution';
+    } else if (regexGal.test(source.u_distinguishedname)) {
+        target.u_group_type = 'legacy';
+    } else if ((regexSec1.test(source.u_distinguishedname)) || (regexSec2.test(source.u_distinguishedname)) || (regexSec3.test(source.u_distinguishedname))) {
+        target.u_group_type = 'security';
+    } else if (regexSNow.test(source.u_distinguishedname)) {
+        target.u_group_type = 'servicenow';
+    } else if ((regexAdmin1.test(source.u_distinguishedname)) || (regexAdmin2.test(source.u_distinguishedname)) || (regexAdmin3.test(source.u_distinguishedname))) {
+        target.u_group_type = 'administration';
+    }
+})(source, target, map, log, action==="update");
+</code>
+----