I had a simple request the other day that I wanted to log on this site since I\u00a0vaguely remember having to do it before.<\/p>\n
A quick background –\u00a0Our company has merged with another company which means we will be busy in the coming months with implementing a new domain. One thing we need to do is create new accounts on the new domain for all the users in each of the existing domains. Since we have thousands of user accounts\u00a0 (some internal and some external or contractors) we needed a way to find out which of these accounts have been used in an X number of days.<\/p>\n
The easiest and quickest way I could think to do this is to create a PowerShell\u00a0Script to query the AD and get the Last Login variable from the account. Problem that I found was that the AD account will record the Login with the Domain Controller that it logs in to. If you have more than one domain controller (you have more than one right!!??) the domain controllers don’t\u00a0sync that login info. So below is the code used to query the domain controllers and get the last logon info from each.<\/p>\n
Disclaimer – I didn’t not write this code but found it after sorting through several google searches. If you wrote this .. thank you. I am putting it here for my own reference so next time I am asked to get the information I will know right where to look.<\/p>\n
[code]<\/p>\n
$datetime\u00a0= Get-Date -Format \u201cyyyyMMddhhmmss\u201d;<\/p>\n
# Create and Add Headers to CSV<\/p>\n
Add-Content \u201cc:tempLastLogin – $datetime.csv\u201d \u201cUser,Last Logon\u201d;<\/p>\n
Get-QADUser\u00a0| ForEach-Object {
\nWrite-Host $_.Name
\nWrite-Host $_.LastLogon
\n$user = $_.Name
\n$time = $_.LastLogon
\n$sc = [char]34<\/p>\n
# Add Data to CSV<\/p>\n
Add-Content \u201cc:tempLastLogin – $datetime.csv\u201d \u201c$sc$user$sc,$sc$time$sc\u201d<\/p>\n
}<\/p>\n
[\/code]<\/p>\n
Steps are to:<\/p>\n
I also combined this with a PowerShell\u00a0Script to create a SharePoint List but that is a different post on a different Blog (at a different time)<\/p>\n","protected":false},"excerpt":{"rendered":"
I had a simple request the other day that I wanted to log on this site since I\u00a0vaguely remember having to do it before. A quick background –\u00a0Our company has merged with another company which means we will be busy in the coming months with implementing a new domain. One… Continue reading