Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Clear-Host
- del .\allDevices.csv
- $allDevices = Get-ADComputer -LDAPFilter "(&(ObjectCategory=Computer)(!OperatingSystem=*Server*))" -Properties OperatingSystem,OperatingSystemVersion
- $allDeviceNames = $allDevices.Name
- [int]$below22H2 = 0
- [int]$above22H2 = 0
- [int]$xAxis = 0
- [int]$yAxis = 0
- [string]$mergeDetails = ""
- $deviceArray = New-Object 'object[,]' $allDeviceNames.Count,3
- $W101507 = 10240
- $W101511 = 10586
- $W101607 = 14393
- $W101703 = 15063
- $W101709 = 16299
- $W101803 = 17134
- $W101809 = 17763
- $W101903 = 18362
- $W101909 = 18363
- $W102004 = 19041
- $W1020H2 = 19042
- $W1021H1 = 19043
- $W1021H2 = 19044
- $W1022H2 = 19045
- $W1121H2 = 22000
- $W1122H2 = 22621
- ForEach($device in $allDevices)
- {
- $osData = $device.OperatingSystemVersion
- $osBuild = ($osData -split '[()]')[1]
- Write-Host ""
- switch($osBuild)
- {
- $W101507
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1507"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101511
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1511"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101607
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1607"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101703
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1703"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101709
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1709"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101803
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1803"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101809
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1809"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101903
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1903"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W101909
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 1909"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W102004
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 2004"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W1020H2
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 20H2"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W1021H1
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 21H1"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W1021H2
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 21H2"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $below22H2++
- }
- $W1022H2
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 22H2"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $above22H2++
- }
- $W1121H2
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 21H2"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $above22H2++
- }
- $W1122H2
- {
- $mergeDetails = ""
- $deviceArray[$xAxis,$yAxis] = $device.Name
- $mergeDetails = $mergeDetails + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $device.OperatingSystem
- $mergeDetails = $mergeDetails + "," + $deviceArray[$xAxis,$yAxis]
- $y++
- $deviceArray[$xAxis,$yAxis] = $osBuild
- $mergeDetails = $mergeDetails + ",Build " + $deviceArray[$xAxis,$yAxis]
- $y++
- $mergeDetails = $mergeDetails + ",Version 22H2"
- $mergeDetails | Out-File .\allDevices.csv -Append
- $above22H2++
- }
- }
- $y = 0
- $x++
- }
- Write-Host ""
- $below22H2
- $above22H2
Advertisement
Add Comment
Please, Sign In to add comment