?
Solved

Mailboxes Not Accessed for certain time

Posted on 2013-06-08
13
Medium Priority
?
875 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 22

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 46

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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
LVL 22

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
 
LVL 22

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 22

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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The article is for all the Exchange users seeking smooth and effective EDB to PST conversion. Exchange Server is the most widely used platform for messaging with collaborative sharing, Exchange online, secure working environment, etc.
Importing Outlook PST contacts to Exchange Server can become a complicated task. Situations arise where an Exchange user is not able to import contacts from PST to Exchange Mailboxes in an efficient manner. Try SysTools Exchange Import to move conta…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

568 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