List Active Directoy computers

Question

Hi!
I need to get a list of computers in Active Directory in the form of a table consisting of columns: Name, Operating System, Operating System Version, mark, if the last login date is more than 365 days.I used this command:
get-adcomputer -properties * -filter * | ft Name, OperatingSystem, OperatingSystemVersion, LastLogonDate >c:\Downloads\computers.txt
But in the LastLogonDate field I get the date of the last login. How can I output TRUE instead, for example, if the last login was performed for more than 365 days?

Answer 1

Hi @Михаил Андросов ,

maybe this helps to get your requirement done:

$dateTime = (Get-Date).AddDays(-380) # Get Date - x days - for testing  
$threshold = (Get-Date).AddDays(-365) # define threshold for "old" in - x days  
# here we go  
$a = $dateTime |  
    Select-Object Date,@{ Name = 'isOld' ; Expression = { If ($_ -lt $threshold ) {$true} else {$false}} }  
$a  

And here your script ( Not tested by myself !!! ):

$threshold = (Get-Date).AddDays(-365) # define threshold for "old" in - x days  
Get-AdComputer -properties -filter |   
    Select-Object Name,OperatingSystem,OperatingSystemVersion,LastLogonDate,@{ Name = 'isOld' ; Expression = { If ($_.LastLogonDate -lt $threshold ) {$true} else {$false}} } |   
        Out-File -Encoding utf8 -FilePath "C:\Downloads\computers.txt"  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Thank you so much for your help. Your option worked perfectly.