Problem:
How do I check the date of cells within a csv file using PowerShell
DailySysAdmin | For all things IT!
A resource for Sys Admins & IT Pros
Problem:
How do I check the date of cells within a csv file using PowerShell
Problem:
I wanted to use PowerShell to get the MFA enabled or disabled status of Office 365 and Azure users and type of MFA used, then output the results to a .csv file.
Problem:
How do I export a list of all Active Directory to a .csv file users using PowerShell?
Continue reading “Export all AD users to csv using PowerShell”
This is a very useful line of code that will list all of the members of a particular Active Directory group and send the output to a .csv file.
Get-ADGroupMember -Identity "Test Group" | export-csv c:\temp\GroupMembers.csv
If you want to find out when user’s passwords will expire and export them to a .csv file then this will help. This simple script will list all of your active users, sort the list and list the expiry dates.
Import-Module ActiveDirectory Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties "SamAccountName","msDS-UserPasswordExpiryTimeComputed" | Select-Object -Property "SamAccountName", @{Name="Password Expiry Date"; Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} | sort "SamAccountName" | export-csv c:\temp\expire.csv -NoTypeInformation
You can also modify the script so that all you need to do is enter the username and get the expiry date:
Import-Module ActiveDirectory Add-Type -AssemblyName Microsoft.VisualBasic $username = [Microsoft.VisualBasic.Interaction]::InputBox('Enter users SamAccountName', 'SamAccountName') Get-ADUser $username –Properties "SamAccountName","msDS-UserPasswordExpiryTimeComputed" | Select-Object -Property "SamAccountName", @{Name="Password Expiry Date"; Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} | sort "SamAccountName" | Out-GridView
If you are running the script from a desktop machine ensure that PowerShell is running as admin and that you have the RSAT tools installed.
Sometimes when trying to find particular updates and troubleshoot Windows update problems you need to be able to manipulate the update data. Using the ‘installed updates’ applet is not always practical. I use the below script to give me a .csv files with all updates installed on a machine.
Continue reading “Use PowerShell to list and export all updates from a Windows machine”