Export AD Users into CSV with lastlogon date more than 180 days

Question

Export AD Users into CSV with lastlogon date more than 180 days

Abdulrahman 101

Hi everyone,

I want to export all of my AD users whom have not logged in more than 180 days.

Is there anyway I can do it through Powershell or directly from ADUC?

Thank you..

Anonymous

Import-Module ActiveDirectory  
  
$DaysInactive = 90  
$Time = (Get-Date).Adddays( - ($DaysInactive))  
  
Get-ADUser -Filter { LastLogonTimeStamp -lt $Time -and enabled -eq $true } -Properties * |  
Select-Object Name, LastLogonDate |  
  
Export-Csv "D:\PS\Shailesh_90days_InactiveUsers.csv" -Encoding UTF8 -NoTypeInformation

4 answers

Your answer

Anonymous

2023-06-13T11:10:56.42+00:00

Import-Module ActiveDirectory $DaysInactive = 90 $Time = (Get-Date).Adddays( - ($DaysInactive)) Get-ADUser -Filter { LastLogonTimeStamp -lt $Time -and enabled -eq $true } -Properties * | Select-Object Name, LastLogonDate | Export-Csv "D:\PS\Shailesh_90days_InactiveUsers.csv" -Encoding UTF8 -NoTypeInformation

Answer 1

JimmySalian-2011 42,491

Hi,

Yes copy paste in the powershell and yes try with admin rights to launch powershell.

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Abdulrahman 101 Reputation points

2022-08-29T19:58:31.047+00:00
Hi Jimmy,

I have got the below error.

Import-Module : A positional parameter cannot be found that accepts argument '180'.
At line:1 char:1

Import-Module ActiveDirectory $DaysInactive = 180 $Time = (Get-Date). ...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CategoryInfo : InvalidArgument: (:) [Import-Module], ParameterBindingException

FullyQualifiedErrorId : PositionalParameterNotFound,Microsoft.PowerShell.Commands.ImportModuleCommand

Answer 2

Hi,

I have updated the code via the Q&A feature this should work without any spaces or hypen. Thanks @Andreas Baumgarten

Import-Module ActiveDirectory  
  
$DaysInactive = 180  
$Time = (Get-Date).Adddays( - ($DaysInactive))  
  
Get-ADUser -Filter { LastLogonTimeStamp -lt $Time -and enabled -eq $true } -Properties * |  
Select-Object Name, LastLogonDate |  
  
Export-Csv "c:\Export\InactiveUsers.csv" -Encoding UTF8 -NoTypeInformation

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Answer 3

JimmySalian-2011 42,491

Hi Abdul,

Yes you can use this script:

Import-Module ActiveDirectory

$DaysInactive = 180
$Time = (Get-Date).Adddays( - ($DaysInactive))

Get-ADUser -Filter { LastLogonTimeStamp -lt $Time -and enabled -eq $true } -Properties * |
Select-Object Name, LastLogonDate |

Export-Csv "c:\Export\InactiveUsersdate.csv" -Encoding UTF8 -NoTypeInformation

=
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Abdulrahman 101 Reputation points

2022-08-29T19:40:47.467+00:00

Dear Jimmy,

How to use this script? Directly copy paste in Powershell with Admin rights?

Answer 4

JimmySalian-2011 42,491

Hi,

It seems you copied and paste the command there might be some space or characters in the script, just make sure not to put any space between the hyphen(-) and the Name parameter and the same way Don’t put any space between the hyphen(-) and Location parameter.

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2022-08-29T21:22:29.493+00:00
Hi @JimmySalian-2011 ,

the best way to post code and scripts is to use the Code Sample option of the Q&A editor -> The icon with 101010 or use Strg +K.

This way it's very easy to copy the code and the Q&A editor will not remove any character from the code/script.

Paste your code in the Add Code To Your Thread window and click Ok:

The result will look like this:

Import-Module ActiveDirectory $DaysInactive = 180 $Time = (Get-Date).Adddays( - ($DaysInactive)) ..........

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Share via

Export AD Users into CSV with lastlogon date more than 180 days

4 answers

Your answer