GAL Export
I am trying to export our GAL to a .csv file. We are a 2003 domain, and we are running Exchange 2003. I found this article from Microsoft that says to use csvde: http://support.microsoft.com/kb/555397 I used the syntax they provided and subbed in my domain info: csvde -r "(objectClass=user)" -d "dc=subdomain,dc=domain,dc=com" -l displayName,proxyAddresses -f c:\users.csv However, when I look through the csv file I see that it has exported user and computer objects, even though the objectClass only specifies user objects. Is this to be expected? Or am I doing something wrong? I ran this from the command line of the DC as a Domain Admin. The particular DC I used is not a GC. ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja~
RE: GAL Export
objectClass for computer actually contains "user" in the multi-value string, so it is doing exactly what it is told. Try using: -r "(objectCategory=user)" or -r "(objectCategory=Person)". Either one should work as the AD just converts "user" to "CN=Person,CN=Schema,CN=Configuration,DC=domain,DC=com" anways. Of note, this will grab Contact objects as well. If you want to eliminate those, then you can get objectClass=user involved again since the objectClass multi-value for a contact does not contain "user", but contains "contact" instead. So: -r "(&(objectCategory=Person)(objectClass=user))" AD does not convert (objectClass=user), just (objectCategory=user) is. That's not confusing at all is it? ;) From: Rob Bonfiglio [mailto:robbonfig...@gmail.com] Sent: Thursday, June 04, 2009 2:10 PM To: MS-Exchange Admin Issues Subject: GAL Export I am trying to export our GAL to a .csv file. We are a 2003 domain, and we are running Exchange 2003. I found this article from Microsoft that says to use csvde: http://support.microsoft.com/kb/555397 I used the syntax they provided and subbed in my domain info: csvde -r "(objectClass=user)" -d "dc=subdomain,dc=domain,dc=com" -l displayName,proxyAddresses -f c:\users.csv However, when I look through the csv file I see that it has exported user and computer objects, even though the objectClass only specifies user objects. Is this to be expected? Or am I doing something wrong? I ran this from the command line of the DC as a Domain Admin. The particular DC I used is not a GC. ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja~
RE: GAL Export
I get both computer and user account info as well. Don Guyer Systems Engineer - Information Services Prudential, Fox & Roach/Trident Group 431 W. Lancaster Avenue Devon, PA 19333 Direct: (610) 993-3299 Fax: (610) 650-5306 don.gu...@prufoxroach.com From: Rob Bonfiglio [mailto:robbonfig...@gmail.com] Sent: Thursday, June 04, 2009 3:10 PM To: MS-Exchange Admin Issues Subject: GAL Export I am trying to export our GAL to a .csv file. We are a 2003 domain, and we are running Exchange 2003. I found this article from Microsoft that says to use csvde: http://support.microsoft.com/kb/555397 I used the syntax they provided and subbed in my domain info: csvde -r "(objectClass=user)" -d "dc=subdomain,dc=domain,dc=com" -l displayName,proxyAddresses -f c:\users.csv However, when I look through the csv file I see that it has exported user and computer objects, even though the objectClass only specifies user objects. Is this to be expected? Or am I doing something wrong? I ran this from the command line of the DC as a Domain Admin. The particular DC I used is not a GC. ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja~
RE: GAL Export
Computers are a derived class (subclass) of users. If you only want user accounts, use this filter: "(&(objectClass=user)(objectCategory=person))" From: Don Guyer [don.gu...@prufoxroach.com] Sent: Thursday, June 04, 2009 4:00 PM To: MS-Exchange Admin Issues Subject: RE: GAL Export I get both computer and user account info as well. Don Guyer Systems Engineer - Information Services Prudential, Fox & Roach/Trident Group 431 W. Lancaster Avenue Devon, PA 19333 Direct: (610) 993-3299 Fax: (610) 650-5306 don.gu...@prufoxroach.com<mailto:don.gu...@prufoxroach.com> From: Rob Bonfiglio [mailto:robbonfig...@gmail.com] Sent: Thursday, June 04, 2009 3:10 PM To: MS-Exchange Admin Issues Subject: GAL Export I am trying to export our GAL to a .csv file. We are a 2003 domain, and we are running Exchange 2003. I found this article from Microsoft that says to use csvde: http://support.microsoft.com/kb/555397 I used the syntax they provided and subbed in my domain info: csvde -r "(objectClass=user)" -d "dc=subdomain,dc=domain,dc=com" -l displayName,proxyAddresses -f c:\users.csv However, when I look through the csv file I see that it has exported user and computer objects, even though the objectClass only specifies user objects. Is this to be expected? Or am I doing something wrong? I ran this from the command line of the DC as a Domain Admin. The particular DC I used is not a GC. ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja~
Re: GAL Export
Thank you to all three of you. Using the filter below got what I needed. On Thu, Jun 4, 2009 at 4:28 PM, Michael B. Smith wrote: > Computers are a derived class (subclass) of users. > > If you only want user accounts, use this filter: > "(&(objectClass=user)(objectCategory=person))" > > -- > *From:* Don Guyer [don.gu...@prufoxroach.com] > *Sent:* Thursday, June 04, 2009 4:00 PM > *To:* MS-Exchange Admin Issues > *Subject:* RE: GAL Export > >I get both computer and user account info as well. > > > > Don Guyer > > Systems Engineer - Information Services > > Prudential, Fox & Roach/Trident Group > > 431 W. Lancaster Avenue > > Devon, PA 19333 > > Direct: (610) 993-3299 > > Fax: (610) 650-5306 > > don.gu...@prufoxroach.com > > > > *From:* Rob Bonfiglio [mailto:robbonfig...@gmail.com] > *Sent:* Thursday, June 04, 2009 3:10 PM > *To:* MS-Exchange Admin Issues > *Subject:* GAL Export > > > > I am trying to export our GAL to a .csv file. We are a 2003 domain, and we > are running Exchange 2003. > > I found this article from Microsoft that says to use csvde: > > http://support.microsoft.com/kb/555397 > > > > I used the syntax they provided and subbed in my domain info: > > csvde -r "(objectClass=user)" -d "dc=subdomain,dc=domain,dc=com" -l > displayName,proxyAddresses -f c:\users.csv > > > > > > However, when I look through the csv file I see that it has exported user > and computer objects, even though the objectClass only specifies user > objects. Is this to be expected? Or am I doing something wrong? > > I ran this from the command line of the DC as a Domain Admin. The > particular DC I used is not a GC. > > > > > > > ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja~