Export Active directory user list to excel | Get-Aduser to Excel or CSV | Active Directory users analysis | Active Directory Audit

Active Directory Audit and DataAnalysis

 Export Active directory user list to excel | Get-Aduser to Excel or CSV | Active Directory users analysis 

Run below Quary → Export →Active Directory user list→ “Excel / MSSQL” , This is very useful to analysis no longer users and last logon analytics 

Get-ADUser -Filter * -Properties * |select DisplayName, EmailAddress, mail, msExchWhenMailboxCreated, whenCreated, whenChanged, lastLogonDate, Enabled, DistinguishedName | Export-Csv C:\Users\Aravinth.Groupit\Downloads\Report1.csv