So using the lDAP import, you can bring users into KACE.  This import can be modified to pull almost any information from your AD to your KACE user table, by mapping it to the CUSTOM fields.

One thing I liked to map, was the Manager field.  But boy was it ugly when it came in, CN=MANAGER NAME, followed by a lot of jibber jabber of OU's.

I wanted JUST THE MANAGER name (and I could use that field has a reference to the manager as a user through USER.FULL_NAME !


For those that are not SQL wizards, and I am VERY much not a SQL wizard AT ALL, i thought it might be helpful to share with you a little ticket rule that runs 5 minutes after the morning LDAP import.

 
 update `USER`
Set `CUSTOM_3` =
 IF(
        LOCATE('CN=', `CUSTOM_3`)  > 0,
        SUBSTRING(`CUSTOM_3`, 4, LOCATE(',', `CUSTOM_3`) - 4),
        `CUSTOM_3`
    )

This little guy runs, and cleans up the whole mess and leaves me with just a manager name.

 

NOTE:  I mapped my manager name to CUSTOM_3, and you may need to adjust accordingly.


Double NOTE:  If someone found a much easier way to do this, or fancier, let me know, as I always enjoy a good slap against the face at missing the obvious!

 

ENJOY!