GAL reports   

This question has probably already been asked a million times, here goes
with 1,000,001:

Our company has about 14000 employees that are spread across about 60
divisions in the US.  The receptionist at each division manually creates an
Excel spreadsheet for their division, listing just employees for that
division.  Is there an end-user method, or utility, that will allow them to
automate this?

Thanks

date: Wed, 12 Apr 2006 11:11:41 -0400   author:   JohnB

Re: GAL reports   

Give'em a script that dumps the info from AD into a csv file.

Assuming you have some attribute on each user that is unique to each 
division you can use any of many tools to get this data.  Specifically 
talking out of the box you can use csvde (support tools i think) to create a 
simple shell script that makes it pretty;
csvde -f div1.csv -d "ou=myUsersOU,dc=company,dc=com" -r 
"(&(objectcategory=person)(uniqueAttribute=div1)" -l 
displayName,mail,telephoneNumber

in that example "uniqueAttribute" can be whatever you use to differentiate 
the divisions, department, location, etc.

alex

"JohnB"  wrote in message 
news:uEWQqNkXGHA.4388@TK2MSFTNGP03.phx.gbl...
> This question has probably already been asked a million times, here goes
> with 1,000,001:
>
> Our company has about 14000 employees that are spread across about 60
> divisions in the US.  The receptionist at each division manually creates 
> an
> Excel spreadsheet for their division, listing just employees for that
> division.  Is there an end-user method, or utility, that will allow them 
> to
> automate this?
>
> Thanks
>
>

date: Thu, 13 Apr 2006 00:35:36 -0700   author:   Alex Fontana

Re: GAL reports   

Here's a tool that might .

You could aslo setup a script on server to schedule an  export to a 
directory in a file share. The end user could then grab the data.

Ather way is to generate it the data centrally and email out the file to a 
distribution group.



"JohnB"  wrote in message 
news:uEWQqNkXGHA.4388@TK2MSFTNGP03.phx.gbl...
> This question has probably already been asked a million times, here goes
> with 1,000,001:
>
> Our company has about 14000 employees that are spread across about 60
> divisions in the US.  The receptionist at each division manually creates 
> an
> Excel spreadsheet for their division, listing just employees for that
> division.  Is there an end-user method, or utility, that will allow them 
> to
> automate this?
>
> Thanks
>
>

date: Fri, 14 Apr 2006 17:23:17 +1000   author:   Andrew Sword [MVP]