Solved

Mailboxes Not Accessed for certain time

Posted on 2013-06-08
13
720 Views
Last Modified: 2013-06-18
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
Comment
Question by:cciedreamer
  • 8
  • 4
13 Comments
 
LVL 21

Expert Comment

by:Haresh Nikumbh
ID: 39231408
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
 
LVL 38

Expert Comment

by:Vasil Michev (MVP)
ID: 39231432
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
 
LVL 3

Author Comment

by:cciedreamer
ID: 39231438
Hi,
Thanks for the reply. Is there any to get status based on groups.

Thanks
0
 
LVL 21

Expert Comment

by:Haresh Nikumbh
ID: 39231445
get-mailboxstatistics -server am-lon-ex02 | where {($_.LastLogonTime -lt (get-date).adddays(-30)) -and ($_.ObjectClass -eq "Mailbox")} | out-file mailboxes.txt
0
 
LVL 3

Author Comment

by:cciedreamer
ID: 39231531
Currently I am using Promodag reports to generate exchange reports I am not this will fulfill my requirement

Thanks
0
 
LVL 3

Author Comment

by:cciedreamer
ID: 39231572
The above script is batch file or vb script ??

Thanks
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 21

Expert Comment

by:Haresh Nikumbh
ID: 39231585
mine is exchange powershell
0
 
LVL 3

Author Comment

by:cciedreamer
ID: 39231607
How I can run the above command with exchange shell. Just copy and paste the above script ??
0
 
LVL 21

Expert Comment

by:Haresh Nikumbh
ID: 39231616
yes  just replace this
am-lon-ex02
your exchange server name
0
 
LVL 3

Author Comment

by:cciedreamer
ID: 39231760
Do you I have to completely copy the script ( replacing server name ) and paste it to exchange powershell.

THanks
0
 
LVL 3

Author Comment

by:cciedreamer
ID: 39232001
I ran the commands but it ended as shown and not file was createdpowershell
Please any advise.
0
 
LVL 3

Accepted Solution

by:
cciedreamer earned 0 total points
ID: 39245399
Thanks for the experts help.
I solved it myself using Promodag Reporting Tool.
0
 
LVL 3

Author Closing Comment

by:cciedreamer
ID: 39255614
Thanks for the experts help.
I solved it myself using Promodag Reporting Tool.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Utilizing an array to gracefully append to a list of EmailAddresses
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now