Hey I'm all for holidays where I am the guest of honor. :o) I wonder if I could get it off with pay from work?
Seriously though, I am glad you find the tools useful. When I first started the website and official sharing of the tools in 2001 I had no idea it would be as popular as it has been. I had had years of knowing I had a lot of issues with the tools that were available (or unavailable as the case mostly was) but when I looked around so many people, especially local MS people, didn't seem to notice any lack and were firmly parked in the gui. I hoped that there were at least a few people who wanted to do things at the command line and couldn't because they didn't have the programming background and I could help them. So I set it all up. I was right that there were people who wanted to do the things, just wrong on the numbers. :o) I get about 4000 downloads a month at the moment and that is growing pretty steadily. About 6000 unique visitors a month. I am having a great time with it. joe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Creamer, Mark Sent: Friday, October 08, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Awesome. Actually your existing tools have already saved me so much time, we should have Joe Day here at Cintas! Need a nice navy uniform to work in your garage? Thanks Joe! <mc> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Friday, October 08, 2004 10:46 AM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Yeah single value attribs aren't so difficult. They align fine. Unfortunately some of the really useful attribs that people like to get are member or memberof or homeMDBBL, etc. Of course I could chose to output like CSVDE does and do the same in excel where as you say, all multivals are in the same cell or within a quoted string with semicolon delimiters in there but I can forsee the additional emails that will generate of the "next" enhancement after that and would like to chop it off at the pass. I need to think some more on this. If you (or anyone obviously) thinks up some smooth way of displaying this info, basically single and multivalues all in a single line/row of output, let me know. Honestly, the most likely scenario will be a CSV output from adfind versus writing an excel add-in. Excel add-ins are a ways off from what I tend to do unless being paid really well for it and while I like excel for making confusing looking delimited text files look nice, I would rather work towards the import route versus directly interface with Excel. I really dislike working with OLE/COM/etc from c/c++ - it isn't elegant. I may however whip up a nice perl script to go with adfind though as that is something I have done previously, have perl build excel spreadsheets that is. joe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Creamer, Mark Sent: Friday, October 08, 2004 10:26 AM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications I guess that's where my knowledge falls weak, Joe. But I think for the multi-valued, if all of the values for that attribute were in a single cell, that would be a great start. (I'm not asked for MVAs very often, so that may be more of an issue for some folks than it is to me). Let's say someone asked me for all the employees whose Employee ID=12345*, and return their sAMAccountName, EmployeeID, distinguishedName and then a MVA called myOfficeLocations. >From Excel, I choose the query interface in the Data menu. It brings up >a free-form query dialog, where I enter my query (LDAP? ADO?), and then returns the answer to the spreadsheet: MarkC|1234577|cn=Creamer\, Mark,cn=Users,dc=[etc]|101 102 103| Where each value above between the pipes is a cell in Excel <mc> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Friday, October 08, 2004 10:10 AM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications What would you visualize the layout of the information in the spreadsheet to be? I.E. You have single value attributes and multivalue attributes. How do you represent them in a cell format? This is one of the things I have battled with myself on creating csv based ouput which is the same problem for putting info straight into an excel table. joe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Creamer, Mark Sent: Thursday, October 07, 2004 4:37 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications I know - so far I haven't been too successful. If Joe thinks it's a worthwhile spinoff of adfind's many capabilities, I sure won't complain :-) <mc> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Murray Sent: Thursday, October 07, 2004 4:33 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Yeah, but you don't need Joe to do that, you can do it anyway with Excel VBA and ADO (which supports SQL style queries to AD). Tony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Creamer, Mark Sent: Donnerstag, 7. Oktober 2004 22:04 To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Yep, or even fancier...I had in mind an Excel menu item Data\Import External Data\New AD Query Select Users where sAMAccountName=JoeIs* JoeIsCool JoeIsFunny JoeIsNotTooBusyToDoThis :-) <mc> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Thursday, October 07, 2004 3:51 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Hmmm so you are asking for CSV output from ADFIND... That has been asked for before. I have that on the list. Maybe it is time. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Creamer, Mark Sent: Thursday, October 07, 2004 3:35 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications Joe, cool new site design! Would this be creative enough? How 'bout an Excel add-in that would allow someone to query AD from within the Excel interface and return the results to the spreadsheet? <mc> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Thursday, October 07, 2004 3:19 PM To: [EMAIL PROTECTED] Subject: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications In case you haven't noticed, Windows NT Mag got renamed yet again. Now it is the Windows IT Pro mag and is on newsstands now. Robbie has a good article in there about AD command line tools. :o) Also FYI, completely redesigned my website. Any update requests for admod/adfind/oldcmp and any of the others that you feel you really want, send now as I will be finishing up a book tech review pretty quickly and looking to do something creative. joe List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
