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

IBM i: DB2 for i

IBM DB2 for i DB2 for i is a member of IBM’s family of DB2 databases. What makes DB2 for i unique is its integration with the platform, the IBM i operating system and Power Systems. This unique integration means you do less managing of your database, and more building of applications for analytics, mobile, cloud, or day to day operational purposes. DB2 for i’s open standards support allows you to leverage the world of development tools while protecting your investment in legacy applications. Self managing is what DB2 for i is all about ! Let's ST a R t SQL with STRSQL command. Query all databases SELECT DISTINCT table_schema FROM systables Query returns list of all databases

Microsoft Office 365: Compare all plans

Check Get the latest advanced features with Office 365 for the lastest update and price. Check Get Office 365 free for your entire school for Education plans.

Powershell: head and tail command

Use head or tail to skim the first or last 5 lines.

luyện

Search This Blog