Integrating Real-Time SQL Triggers to manage Active Directory Accounts with UMRA

Written by: Allan Bogh
Published on by
Reply
Triggers allow a set of SQL code to run on several types of SQL actions, such as INSERT, UPDATE, or DELETE. For instance, upon an INSERT, the SQL engine will call the trigger configured for the INSERT action. The trigger specified will have programming logic to perform actions on other systems. With OLE Automation enabled in SQL, the trigger will have the ability to perform actions using COM objects. Continue reading →

AD GUIDs (UUIDs) – “friendly” vs. “non-friendly” hex

Written by: Allan Bogh
Published on by
Reply
A colleague of mine asked a very good question about user GUIDs stored in Active Directory. He noticed that a GUID (objectGUID in adsiedit) is displayed in the format: ffffffff-ffff-ffff-ffff-ffffffffffff (8-4-4-4-12), but when shown in the attribute editor it’s displayed in the standard hexadecimal form “FF FF FF FF…”. An automation program we work with displays it in a different format: “fffffffffffff…”. Why are these GUIDs displayed in different formats? Continue reading →