Skip to main content

Powershell: Get-ADUser

# Users last logon more than 180 days

PS C:\Windows\system32>Import-Module ActiveDirectory

PS C:\Windows\system32>$today = Get-Date -Format yyyyMMdd

PS C:\Windows\system32>$date = (Get-Date).AddDays(-180)

PS C:\Windows\system32> Get-ADUser -Filter {LastLogonDate -lt $date} -Properties * | Select Name,SamAccountName,Office,LastLogonDate | Sort-Object Office | Export-Csv -Path C:\Audit\last-logon-180-days-$today.csv -NoTypeInformation


Popular posts from this blog

Powershell: Check Bad Logon

get-aduser -Filter {BadLogonCount -ne 0} -properties * | select SamAccountName,BadLogonCount,BadPasswordTime,BadPwdCount,@{name='badPasswordTimeDT'; expression={[datetime]::fromFileTime($_.badPasswordTime)}} | sort BadPasswordTime | FT

MSSQL: Fix error 'Consistency validation for SQL Server registry keys'

While installing Microsof SQL Server 2012, I ran into the following error. "The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys." How to fix Replace the D:\x64\FixSqlRegistryKey_x86.exe file with the original file from the ENU\SQLFULL_ENU.iso file downloading from Microsoft Download Center. This ISO file is 4.2GB. So you can click FixSqlRegistryKey_x86.exe to download this file only. After replacing that file, press Re-run to check. All rules are passed.