Free Active Directory User Import Script - Kayako

landspeed · 05:51 PM

Attached is my utility to query your AD and import the users into the SupportSuite. This will help in the issue in which the user hasn't logged into the system before they email a ticket in.

I'd be happy to help with any issues you may have but the utility comes as is and don't expect it to work 100%

Enjoy.

***Varun Shoor*** · 14-01-2007, 06:07 PM

Excellent work, Thanks for sharing.

Regards,

Varun Shoor

jpuff · 08-02-2007, 08:40 PM

Has anyone tried this?

arty72 · **Import from AD -** 20-08-2007, 04:30 PM

HiLandspped,

The import function appears to work fine, however I just want to import the users and assign them all a default password and then use the standard esupport login routine to login. I have modified your file to include the default group and SLA I want to assign them but I cannot sign in.

Regards
arty72

landspeed · 19-09-2007, 05:22 PM

If you are assigning them a default password did you change the authentication type?

tdsmith · **Active directory import -** 10-03-2008, 05:52 PM

I want to perform an import from active directory instead of rely on the users to access the portal. I want to import username, email and password so if they ever so want to access the portal it will work. I am using AD integration but the process requires the user to login to populate the database. How can I accomplish this?

T

landspeed · 11-03-2008, 03:47 PM

Did you try the code tdsmith?

asiri · 05:03 AM

This is brilliant. Works like a charm. Thank you very much.

m374llic4 · 04:20 PM

I keep getting No Results Found.

landspeed · 10-09-2008, 05:14 AM

I'd verify that the variables in that script are correct. Make sure your DN is valid, you have the correct domain controller and the username and password for the ldap connection has access to perform the query.

asiri · 18-09-2008, 07:15 AM

You could perhaps use the ldp tool to find the correct DN settings as explained here.

adr132 · **ran script unsuccessfully -** 29-09-2008, 08:06 PM

The script appeared to to run successfully stating that it had imported 1000 accounts, but there are no new users to be found??? It also ran much to fast for 1000 users to have been imported. Anything that i could be doing wrong or forgetting???

adr132 · 01:48 PM

I needed to use the "samaccountname". This worked for me. You can also modify the script to add only new AD users that have not yet been added to swusers table and schedule the script to run daily so that your user database is always up to date preventing users from getting locked out if a phone ticket is created before initial log in. I also was able to change a few things, and use the script to import my contacts from AD as well. Great script, Thanks!

RoadRashTX · 20-10-2008, 03:30 PM

So is this the only way to deal with users that are not in the system and have never created a ticket? In our AD system we have a lot of users and I know that only a fraction of them will ever access our helpdesk. Is there an easier way to deal with users that submit a ticket for the first time but have never logged in?

adr132 · **there is no other way that i've found -** 22-10-2008, 06:38 PM

I searched everywhere and even submitted a ticket with kayako asking for alternative ideas, but Kayako support said that this was not possible. This is the only way that i could accomplish this. I was very close to throwing out kayako all together until i stumbled on this script and tweaked it a bit.

I actually didn't end up importing the contacts, it worked, but decided to use the "phonenumber" field that is in the swusers table instead, so i made the script import the data from ad that i wanted into the swusers table. This way there is only one table to keep up to date. Although the phone number field is kind of "hidden" in the swusers table, when searching for someone that calls, it does show their phone number, email address, and name.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Active directory integration	c-wex	Installation & Upgrading	156	23-07-2008 11:27 AM
Separate Template Groups and MS Active Directory	cglenn	How do I?	0	24-06-2008 07:08 PM
User registration & Active Directory	ksys	SupportSuite, eSupport and LiveResponse	1	11-03-2007 07:41 PM
Active Directory Invalid User Name/PW	Manny	SupportSuite, eSupport and LiveResponse	7	29-09-2006 01:33 AM

*Varun Shoor* Offline Chief Executive Officer Posts: 2,651 Join Date: May 2003	14-01-2007, 06:07 PM Excellent work, Thanks for sharing. Regards, Varun Shoor Varun Shoor (varun.shoor ]at[ kayako.com) ------------------------------------------------------------------- New to the forum? New user's guide here. Submit a bug report here. Submit support tickets via the members area. Submit sales queries either via live chat or via e-mail.

jpuff Offline Member Posts: 78 Join Date: Aug 2006	08-02-2007, 08:40 PM Has anyone tried this?

arty72 Offline New Member Posts: 1 Join Date: Aug 2007	Import from AD - 20-08-2007, 04:30 PM HiLandspped, The import function appears to work fine, however I just want to import the users and assign them all a default password and then use the standard esupport login routine to login. I have modified your file to include the default group and SLA I want to assign them but I cannot sign in. Regards arty72

landspeed Offline New Member Posts: 10 Join Date: Jan 2007	19-09-2007, 05:22 PM If you are assigning them a default password did you change the authentication type?

tdsmith Offline New Member Posts: 1 Join Date: Mar 2008	Active directory import - 10-03-2008, 05:52 PM I want to perform an import from active directory instead of rely on the users to access the portal. I want to import username, email and password so if they ever so want to access the portal it will work. I am using AD integration but the process requires the user to login to populate the database. How can I accomplish this? T

landspeed Offline New Member Posts: 10 Join Date: Jan 2007	11-03-2008, 03:47 PM Did you try the code tdsmith?

asiri Offline New Member Posts: 7 Join Date: Jun 2008	01-08-2008, 07:52 AM This is brilliant. Works like a charm. Thank you very much. Last edited by asiri; 07-08-2008 at 05:03 AM..

m374llic4 Offline New Member Posts: 10 Join Date: Jul 2007	09-09-2008, 04:04 PM I keep getting No Results Found. Last edited by m374llic4; 09-09-2008 at 04:20 PM..

landspeed Offline New Member Posts: 10 Join Date: Jan 2007	10-09-2008, 05:14 AM I'd verify that the variables in that script are correct. Make sure your DN is valid, you have the correct domain controller and the username and password for the ldap connection has access to perform the query.

asiri Offline New Member Posts: 7 Join Date: Jun 2008	18-09-2008, 07:15 AM You could perhaps use the ldp tool to find the correct DN settings as explained here.

adr132 Offline New Member Posts: 15 Join Date: Jun 2008	ran script unsuccessfully - 29-09-2008, 08:06 PM The script appeared to to run successfully stating that it had imported 1000 accounts, but there are no new users to be found??? It also ran much to fast for 1000 users to have been imported. Anything that i could be doing wrong or forgetting???

RoadRashTX Offline New Member Posts: 23 Join Date: Aug 2008	20-10-2008, 03:30 PM So is this the only way to deal with users that are not in the system and have never created a ticket? In our AD system we have a lot of users and I know that only a fraction of them will ever access our helpdesk. Is there an easier way to deal with users that submit a ticket for the first time but have never logged in?