Month: July 2018

Powershell Script to Get List of Active Users with the Details like samaccountname, name, department, job tittle, email in Active Directory

by

  In this blog will see how to list active users with details like samaccountname, name, department, job tittle, email, etc., in Active Directory using powershell script.    A dsquery solution: dsquery * -Filter “(&(objectCategory=person)(objectClass=user))” -Attr givenName sn displayName sAMAccountName mail proxyAddresses distinguishedName > AllUsers.txt   A PowerShell solution using the AD module cmdlet: Get-ADUser … Read more

Powershell Script to Get “lastLogon Timestamp” for Specific OU and Export to CSV File

by

Learn how to get lastlogon timestamp for specific OU and export to CSV by using Powershell script. A PowerShell solution using the AD module cmdlet: Get-ADUser -Filter * -SearchBase “ou=users,dc=contoso,dc=local” -ResultPageSize 0 -Prop CN,lastLogonTimestamp | Select CN,lastLogonTimestamp | Export-CSV -NoType last.csv If you want get a date: Get-ADUser -Filter * -SearchBase “ou=users,dc=contoso,dc=local” -ResultPageSize 0 -Prop … Read more

How to Export a Computer List from Active Directory

by

In this blog will see how to export a computers list from Active Directory by using Powershell script into various formats, including csv and Excel. Open the Powershell ISE → Run the below script, adjust the path for the export: Get-ADComputer -Filter * -Property * | Select-Object Name,OperatingSystem,OperatingSystemVersion,ipv4Address | Export-CSV ADcomputerslist.csv -NoTypeInformation -Encoding UTF8 Using … Read more