Powershell command help

---

Hi all,

I'm needing help guidance on running a PS command that will meet the following criteria s

1: Find all win 7 machines which have logged onto the domain in the past 90 days
2: Identify the users who have logged on via win7 in the past 90 days
3: Narrow the search to a specific IP range
4: Export results into a readable format

Thanks all

Vincent

@Vincent-Walker

That's going to be a lot of work. What do you have so far?

Here is a script that does some of it...
https://gallery.technet.microsoft.com/scriptcenter/Get-All-AD-Users-Logon-9e721a89

Here are a couple of comands that should prove useful...
get-adcomputer -filter { OperatingSystem -like "Windows 7*"}

Export-CSV GetWindowsVersion.csv -NoTypeInformation -Encoding UTF8

Hi Mike,

Managed to pull some worthwhile data from my AD using this script below:

$date = (get-date).AddDays(-104)
get-adcomputer -filter { LastLogonDate -gt $date -and OperatingSystem -like "Windows 7*"} -prop LastLogonDate,OperatingSystem |
select name,lastlogondate,OperatingSystem,distinguishedname | Sort-Object lastlogondate | Export-Csv C:\Users\vwalker\Desktop\Win7Export\win7output.csv

It's not sorting my OU'S out, however it's giving me what I need, I'll manipulate the csv file and mess about with it and save as a excel doc to make it presentable...thankfully in my domain I only have approx 130 ish win 7 machines that are still on the network so the formatting of my spreadsheet wont be to bad...could be worse will 1000's of win 7 machine still on the network!!!

My head needs to sleep now it's getting late in Scotland thanks for all your help mike

Vincent

@Vincent-Walker said in Powershell command help:

@Mike-Rodrick
Managed to pull some worthwhile data from my AD using this script below:
$date = (get-date).AddDays(-104)
get-adcomputer -filter { LastLogonDate -gt $date -and OperatingSystem -like "Windows 7*"} -prop LastLogonDate,OperatingSystem |
select name,lastlogondate,OperatingSystem,distinguishedname | Sort-Object lastlogondate | Export-Csv C:\Users\vwalker\Desktop\Win7Export\win7output.csv
It's not sorting my OU'S out, however it's giving me what I need, I'll manipulate the csv file and mess about with it and save as a excel doc to make it presentable...thankfully in my domain I only have approx 130 ish win 7 machines that are still on the network so the formatting of my spreadsheet wont be to bad...could be worse will 1000's of win 7 machine still on the network!!!