On Sun, 8 Apr 2012 06:32:21 +0000, sphilip14 wrote: >We have Exchange 2007 SP1 with at least 12 different domains. "Domains" as in Active Directory domains, or as in DNS domains? >I need to get user details based on each domain. > >how do I get this list to an excel file with a complete list of users based on each domain. I need the "Display Name", "Primary SMTP Address" & "Storage Group". Okay, that looks like you mean DNS domains. It also looks like you only want mailboxes and you're not interested in any mailuser objects. Something like this might work (it just off the top of my head and hasn't been verified): $d1 = @() # one array for each domain $d2 = @() etc. get-mailbox -resultsize unlimited | foreach { $disp = $_.displayname # get the storage group from the database name $parts = @() $parts = $_.database.split("\") $sg = $parts[1] # get the domain from the email address $e = $_.PrimarySMTPAddress.tostring() $d = $e -match "^.+\@.*$" $d = $matches[1] # create an object to hold the data $x=""|select DisplayName,EMail,SG # populate the object $x.DisplayName = $disp $x.EMail = $e $x.SG = $sg #get the data into the right array switch ($d){ "d1" {$d1+=$x;break} "d2" {$d2+=$x;break} etc. } # export the arrays to separate files $d1 | export-csv 'd1.csv' -notypeinfo $d2 | export-csv 'd2.csv' -notypeinfo etc. >Is it possible to retrieve the list of users who are using POP3/SMTP? Not easily. You'd have to enable logging for those protocols and then parse logs to extract the authentication data. Store the data in a way that lets you extract the user name. You'll have to do that for a while before you have a complete (or mostly complete) set of data. >or RPC over HTTP? The IIS log files on the CAS servers would have that information. Again, you'd have to extract it and keep track of the results for a while before you'll be able to make good use of the data. >or MAPI? That'd be RPC. No, there's no good way to do that. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

On Sun, 8 Apr 2012 06:32:21 +0000, sphilip14 wrote: >We have Exchange 2007 SP1 with at least 12 different domains. "Domains" as in Active Directory domains, or as in DNS domains? >I need to get user details based on each domain. > >how do I get this list to an excel file with a complete list of users based on each domain. I need the "Display Name", "Primary SMTP Address" & "Storage Group". Okay, that looks like you mean DNS domains. It also looks like you only want mailboxes and you're not interested in any mailuser objects. Something like this might work (it just off the top of my head and hasn't been verified): $d1 = @() # one array for each domain $d2 = @() etc. get-mailbox -resultsize unlimited | foreach { $disp = $_.displayname # get the storage group from the database name $parts = @() $parts = $_.database.split("\") $sg = $parts[1] # get the domain from the email address $e = $_.PrimarySMTPAddress.tostring() $d = $e -match "^.+\@.*$" $d = $matches[1] # create an object to hold the data $x=""|select DisplayName,EMail,SG # populate the object $x.DisplayName = $disp $x.EMail = $e $x.SG = $sg #get the data into the right array switch ($d){ "d1" {$d1+=$x;break} "d2" {$d2+=$x;break} etc. } # export the arrays to separate files $d1 | export-csv 'd1.csv' -notypeinfo $d2 | export-csv 'd2.csv' -notypeinfo etc. >Is it possible to retrieve the list of users who are using POP3/SMTP? Not easily. You'd have to enable logging for those protocols and then parse logs to extract the authentication data. Store the data in a way that lets you extract the user name. You'll have to do that for a while before you have a complete (or mostly complete) set of data. >or RPC over HTTP? The IIS log files on the CAS servers would have that information. Again, you'd have to extract it and keep track of the results for a while before you'll be able to make good use of the data. >or MAPI? That'd be RPC. No, there's no good way to do that. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

We have Exchange 2007 SP1 with at least 12 different domains. I need to get user details based on each domain. how do I get this list to an excel file with a complete list of users based on each domain. I need the "Display Name", "Primary SMTP Address" & "Storage Group". Is it possible to retrieve the list of users who are using POP3/SMTP? or RPC over HTTP? or MAPI? Please advise & help. Thank You Philip

How do I get this list to an excel file with a complete list of users based on each domain. I need the "Display Name", "Primary SMTP Address" & "Storage Group. CSVDE -f domain.csv -S DC/GC name of that domain -d "DC=domain,DC=Local" -r "(objectClass=user)" -l displayName, Mail, homemdb You can run the above command for each domain. Is it possible to retrieve the list of users who are using POP3/IMAP? or RPC over HTTP? or MAPI? These information can be retrive using Logparser. http://messagingserversupport.com/2012/01/20/using-logparser-with-iis-logs-to-filter-connection-statistics-for-exchange-server/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Hasnain Shaikh| My blogs: http://messagingserversupport.com