[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 866
  • Last Modified:

Mailboxes Not Accessed for certain time

Hello Experts,
I have exchange 2010 SP2
I am looking for a way to get a report that list the mailboxes based on distribution group that have not been accessed in 15 day or 30 days and export them into excel format.

Please any help

Thanks
0
cciedreamer
Asked:
cciedreamer
  • 8
  • 4
1 Solution
 
Haresh NikumbhSr. Tech leadCommented:
Mailboxes that have never been logged on to:

Get-MailboxStatistics -resultsize unlimited | where {$_.LastLogonTime -eq $null | ft displayName,lastlogontime,lastloggedonuseraccount,servername

List of mailboxes that haven’t been accessed in the last X days. Let’s use 7 days as the value here:

Get-MailboxStatistics -resultsize unlimited | where {$_.LastLogonTime -lt (get-date).AddDays(-7)} | ft displayName,lastlogontime,lastloggedonuseraccount,servername


Source : http://social.technet.microsoft.com/forums/en-US/exchangesvrdeploylegacy/thread/26875361-95a7-47db-ade2-47d3fc8ccf21
0
 
Vasil Michev (MVP)Commented:
If you are going to filter the users based on DG membership, try something like this:

# group name goes here, or obtain it from user prompt
$members = Get-DistributionGroupMember -Identity "sec grp"

$arrResult = @()

# modify the end date here
$date = (get-date).AddDays(-15)

foreach ($m in $members) {
	$objProperties = New-Object PSObject
	$temp = Get-MailboxStatistics -Identity $m.SamAccountName

# skip users that have never logged in
	if (!$temp.LastLogonTime) { continue; }

	if ($temp.LastLogonTime -lt $date) {

# Add another properties to export as necessary

		Add-Member -InputObject $objProperties -MemberType NoteProperty -Name "DisplayName" -Value $m.DisplayName
		Add-Member -InputObject $objProperties -MemberType NoteProperty -Name "SamAccountName" -Value 

$m.SamAccountName
		Add-Member -InputObject $objProperties -MemberType NoteProperty -Name "PrimarySmtpAddress" -Value 

$m.PrimarySmtpAddress
		Add-Member -InputObject $objProperties -MemberType NoteProperty -Name "LastLogonTime" -Value 

$temp.LastLogonTime

		$arrResult += $objProperties
		}
}

# modify export path here
$arrResult | Export-Csv -Path ".\test.csv" -NoTypeInformation

Open in new window

0
 
cciedreamerAuthor Commented:
Hi,
Thanks for the reply. Is there any to get status based on groups.

Thanks
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Haresh NikumbhSr. Tech leadCommented:
get-mailboxstatistics -server am-lon-ex02 | where {($_.LastLogonTime -lt (get-date).adddays(-30)) -and ($_.ObjectClass -eq "Mailbox")} | out-file mailboxes.txt
0
 
cciedreamerAuthor Commented:
Currently I am using Promodag reports to generate exchange reports I am not this will fulfill my requirement

Thanks
0
 
cciedreamerAuthor Commented:
The above script is batch file or vb script ??

Thanks
0
 
Haresh NikumbhSr. Tech leadCommented:
mine is exchange powershell
0
 
cciedreamerAuthor Commented:
How I can run the above command with exchange shell. Just copy and paste the above script ??
0
 
Haresh NikumbhSr. Tech leadCommented:
yes  just replace this
am-lon-ex02
your exchange server name
0
 
cciedreamerAuthor Commented:
Do you I have to completely copy the script ( replacing server name ) and paste it to exchange powershell.

THanks
0
 
cciedreamerAuthor Commented:
I ran the commands but it ended as shown and not file was createdpowershell
Please any advise.
0
 
cciedreamerAuthor Commented:
Thanks for the experts help.
I solved it myself using Promodag Reporting Tool.
0
 
cciedreamerAuthor Commented:
Thanks for the experts help.
I solved it myself using Promodag Reporting Tool.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now