RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications

joe Thu, 14 Oct 2004 16:41:36 -0700

I always look at suggestions Deji. I don't always use them, but I do look. :o)

This is an interesting way of doing it. I will keep it in mind.

joe

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Deji Akomolafe
Sent: Friday, October 08, 2004 11:19 AM
To: [EMAIL PROTECTED]
Subject: RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications

If it's any help (not that you need MY help :)), I do my MVs one line at time in a cell adjacent to the object's name, like so:

User's DisplayName User's Groups

Joe Richards Owl-group

Multi-fangled-group

Nerds-Grp

JoeIsCoolNOT-Group

JoeIsSoNOTFunny-Grp

JoeIsNeverTooBusyToDoAnything-Grp

User's DisplayName User's Email Addresses

Joe Richards [EMAIL PROTECTED]

[EMAIL PROTECTED]

etc, etc

Sincerely,

D�j� Ak�m�l�f�, MCSE MCSA MCP+I

Microsoft MVP - Directory Services

www.readymaids.com - we know IT
www.akomolafe.com
Do you now realize that Today is the Tomorrow you were worried about Yesterday? -anon

From: joe
Sent: Fri 10/8/2004 7:45 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/

RE: [ActiveDir] [OT] Windows IT Pro Magazine and requests for modifications

Reply via email to