Public/Discovery/Get-DiscoveryIntune.ps1
|
function Get-DiscoveryIntune { [CmdletBinding()] param ( [Parameter(Mandatory)] $Tenant ) $PoshPath = Join-Path ([Environment]::GetFolderPath("Desktop")) -ChildPath 'Posh365' $DiscoPath = Join-Path $PoshPath -ChildPath 'Discovery' $TenantPath = Join-Path $DiscoPath -ChildPath "$Tenant\Intune" $Detailed = Join-Path $TenantPath -ChildPath 'Detailed' $CSV = Join-Path $TenantPath -ChildPath 'CSV' $null = New-Item -ItemType Directory -Path $DiscoPath -ErrorAction SilentlyContinue $null = New-Item -ItemType Directory -Path $TenantPath -ErrorAction SilentlyContinue $null = New-Item -ItemType Directory -Path $Detailed -ErrorAction SilentlyContinue $null = New-Item -ItemType Directory -Path $CSV -ErrorAction SilentlyContinue # This needs to use data from below - however this was quickly added and it works well Write-Host "Gathering Policy Assignments" -ForegroundColor Cyan Get-MemAssignments | Export-Csv "$CSV\Assignments.csv" -NoTypeInformation Write-Host "Gathering Conditional Access Policies" -ForegroundColor Cyan Get-ConditionalAccessPolicy | Export-Csv "$CSV\ConditionalAccessPolicy.csv" -NoTypeInformation Write-Host "Gathering Mobile Apps" -ForegroundColor Cyan Get-MemMobileApp | Export-Csv "$CSV\MobileApp.csv" -NoTypeInformation Write-Host "Gathering Mobile App Configurations" -ForegroundColor Cyan Get-MemMobileAppConfig | Export-Csv "$CSV\MobileAppConfig.csv" -NoTypeInformation Write-Host "Gathering Mobile App Configurations Targeted" -ForegroundColor Cyan Get-MemMobileAppConfigTargeted | Export-Csv "$CSV\MobileAppConfigTargeted.csv" -NoTypeInformation Write-Host "Gathering Mobile App Protection Policies - iOS" -ForegroundColor Cyan Get-MemMobileAppProtectioniOS | Export-Csv "$CSV\MobileAppProtectioniOS.csv" -NoTypeInformation Write-Host "Gathering Mobile App Protection Policies - Android" -ForegroundColor Cyan Get-MemMobileAppProtectionAndroid | Export-Csv "$CSV\MobileAppProtectionAndroid.csv" -NoTypeInformation Write-Host "Gathering Mobile Device Compliance Policies - Android at Work" -ForegroundColor Cyan Get-MemMobileDeviceComplianceAndroidWork | Export-Csv "$CSV\MobileDeviceComplianceAndroidWork.csv" -NoTypeInformation Write-Host "Gathering Mobile Device Compliance Policies - iOS" -ForegroundColor Cyan Get-MemMobileDeviceComplianceiOS | Export-Csv "$CSV\MobileDeviceComplianceiOS.csv" -NoTypeInformation Write-Host "Gathering Mobile Device Configuration Profiles - iOS - Device Restrictions" -ForegroundColor Cyan Get-MemMobileDeviceConfigiOSDeviceRestrictions | Export-Csv "$CSV\MobileDeviceConfigiOSDeviceRestrictions.csv" -NoTypeInformation Write-Host "Gathering Mobile Device Configuration Profiles - iOS - Email" -ForegroundColor Cyan Get-MemMobileDeviceConfigiOSEmail | Export-Csv "$CSV\MobileDeviceConfigiOSEmail.csv" -NoTypeInformation Write-Host "Gathering Mobile Device Configuration Profiles - iOS - WiFi" -ForegroundColor Cyan Get-MemMobileDeviceConfigiOSWifi | Export-Csv "$CSV\MobileDeviceConfigiOSWifi.csv" -NoTypeInformation $ExcelSplat = @{ TableStyle = 'Medium2' FreezeTopRowFirstColumn = $true AutoSize = $true BoldTopRow = $false ClearSheet = $true ErrorAction = 'SilentlyContinue' } Get-ChildItem $CSV -Filter "*.csv" | Sort-Object Name | ForEach-Object { Write-Host "Exporting to Excel : " -ForegroundColor White -NoNewline Write-Host "$($_.BaseName)" -ForegroundColor Green Import-Csv $_.fullname | Export-Excel @ExcelSplat -WorksheetName (-join $_.BaseName[0..29]) -Path (Join-Path $TenantPath 'Base_Intune_Discovery.xlsx') if ( $_.BaseName -eq 'App' -or $_.BaseName -eq 'Assignments') { Import-Csv $_.fullname | Export-Excel @ExcelSplat -WorksheetName (-join $_.BaseName[0..29]) -Path (Join-Path $TenantPath 'Intune_Discovery.xlsx') } else { Import-Csv $_.fullname | Format-Vertical | Export-Excel @ExcelSplat -WorksheetName (-join $_.BaseName[0..29]) -Path (Join-Path $TenantPath 'Intune_Discovery.xlsx') } } } |