chromebookinventory_sanitized.ps1

chromebookinventory_sanitized.ps1

#EXPORT DEVICE REPORTS FROM GOOGLE ADMIN CONSOLE - IM TOO LAZY TO CALL GAM OR APIS RIGHT NOW

$date = Get-Date -Format yyyyMMdd

#IMPORT EACH DISTRICT CHROMEBOOK INVENTORY AND ADD A DOMAIN COLUMN FOR LATER FILTERING
$district1cros = Import-Csv -Path C:\chromebooks\district1_chromebooks.csv
$district1cros | Add-Member -MemberType NoteProperty -Name domain -Value district1

$district2cros = Import-Csv -Path C:\chromebooks\district2_chromebooks.csv
$district2cros | Add-Member -MemberType NoteProperty -Name domain -Value district2

$district3cros = Import-Csv -Path C:\chromebooks\district3_chromebooks.csv
$district3cros | Add-Member -MemberType NoteProperty -Name domain -Value district3

$district4cros = Import-Csv -Path C:\chromebooks\district4_chromebooks.csv
$district4cros | Add-Member -MemberType NoteProperty -Name domain -Value district4

$district5cros = Import-Csv -Path C:\chromebooks\district5_chromebooks.csv
$district5cros | Add-Member -MemberType NoteProperty -Name domain -Value district5

$district6cros = Import-Csv -Path C:\chromebooks\district6_chromebooks.csv
$district6cros | Add-Member -MemberType NoteProperty -Name domain -Value district6

$district7cros = Import-Csv -Path C:\chromebooks\district7_chromebooks.csv
$district7cros | Add-Member -MemberType NoteProperty -Name domain -Value district7

#CREATE AN EMPTY ARRAY AND THROW ALL DISTRICT INVENTORIES INTO IT
$allcros = @()
$allcros += $district1cros
$allcros += $district2cros
$allcros += $district3cros
$allcros += $district4cros
$allcros += $district5cros
$allcros += $district6cros
$allcros += $district7cros

#PULL REPORT OF ALL CHROMEBOOKS IN ALL DISTRICTS - IF WANTED, THEN UNCOMMENT
#$allcros | Select-Object -Property domain,model,autoUpdateExpiration,annotatedAssetId,deviceId,serialNumber,lastPolicySync,orgUnitPath,annotatedLocation,annotatedNotes,mostRecentActivity,mostRecentUser | Export-Csv -Path C:\chromebooks\all_chromebooks_$date.csv -NoTypeInformation

#67 MODELS THAT GOOGLE INDICATED WILL BE IMPACTED BY THE OPTIN PROCESS AND LOSE ANDROID APPS AND PLAY STORE
$optinModels = Import-Csv -Path C:\chromebooks\optinmodels.csv

#FIND ALL THE CHROMEBOOKS AFFECTED
$affectedcros = $allcros | Where-Object -FilterScript {$_.model -in $optinModels.model}

#REPORT OF AFFECTED CHROMEBOOKS
$affectedcros | Export-csv -Path C:\chromebooks\affectedchromebooks.csv -NoTypeInformation