Private/Sites/Export.ps1
|
function Write-PSISitesLog([string]$Path,[string]$RunId,[string]$Phase,[string]$Operation,[string]$Outcome,[string]$Target,[string]$Message,[long]$DurationMs=0,[string]$ErrorId=''){ [pscustomobject][ordered]@{Timestamp=[datetimeoffset]::Now.ToString('o');Level=if($Outcome -in @('Failed','TimedOut')){'Warning'}else{'Information'};RunId=$RunId;Phase=$Phase;Target=$Target;Operation=$Operation;Outcome=$Outcome;DurationMs=$DurationMs;Message=$Message;ErrorId=$ErrorId}| ConvertTo-Json -Compress|Add-Content -LiteralPath $Path -Encoding UTF8 } function New-PSIInventoryDashboard($Meta,$Sections,$Data,$Coverage,[string]$ModuleRoot,[string]$ReportBaseName){ $html=[IO.File]::ReadAllText((Join-Path $ModuleRoot 'Templates/Dashboard.html')) $html=$html.Replace('/*DASHBOARD_CSS*/',[IO.File]::ReadAllText((Join-Path $ModuleRoot 'Assets/Dashboard.css'))) $html=$html.Replace('/*JP_BRAND_CSS*/',[IO.File]::ReadAllText((Join-Path $ModuleRoot 'Assets/JP.brand.css'))) $html=$html.Replace('/*DASHBOARD_JS*/',[IO.File]::ReadAllText((Join-Path $ModuleRoot 'Assets/Dashboard.js'))) $fallback=New-Object text.StringBuilder [void]$fallback.Append('<h1>JP | PSInsightInventory - '+[net.webutility]::HtmlEncode($Meta.title)+'</h1><p>'+[net.webutility]::HtmlEncode($Meta.notice)+'</p>') $details='Scope: '+$Meta.scope+' | Version: '+$Meta.version+' | Run: '+$Meta.run+' | Generated: '+$Meta.generatedDisplay [void]$fallback.Append('<p>'+[net.webutility]::HtmlEncode($details)+'</p><p>Open in a browser with JavaScript to explore the inventory. The CSV and JSON files beside this report contain the full export.</p>') foreach($key in $Sections.Keys){ $columns=@($Sections[$key][1]);$records=@($Data[$key]) [void]$fallback.Append('<h2>'+[net.webutility]::HtmlEncode($Sections[$key][0])+' ('+$records.Count+' observed)</h2>') if(-not $records.Count){continue} [void]$fallback.Append('<div class="tablewrap"><table><thead><tr>') foreach($column in $columns){[void]$fallback.Append('<th scope="col">'+[net.webutility]::HtmlEncode($column)+'</th>')} [void]$fallback.Append('</tr></thead><tbody>') foreach($record in ($records | Select-Object -First 5)){ [void]$fallback.Append('<tr>') foreach($column in $columns){[void]$fallback.Append('<td>'+[net.webutility]::HtmlEncode([string](Get-PSISiteValue $record $column))+'</td>')} [void]$fallback.Append('</tr>') } [void]$fallback.Append('</tbody></table></div>') } $browserPayload=[ordered]@{meta=$Meta;sections=$Sections;data=$Data;coverage=$Coverage;reportBaseName=$ReportBaseName} $html=$html.Replace('<!--FALLBACK-->',$fallback.ToString()) if($html -notmatch '/\*DATA\*/' -or $html -match '/\*(?:DASHBOARD_CSS|DASHBOARD_JS|JP_BRAND_CSS)\*/'){throw 'Dashboard template placeholders are invalid.'} $html.Replace('/*DATA*/',(ConvertTo-PSISafeJson $browserPayload)) } function New-PSIInventoryRunFolder([string]$OutputPath,[string]$FolderName){ $null = New-Item -ItemType Directory -Path $OutputPath -Force -ErrorAction Stop for($number = 1; ; $number++){ $name = if($number -eq 1){$FolderName}else{'{0}_{1:00}' -f $FolderName,$number} $path = Join-Path $OutputPath $name try{ $null = New-Item -ItemType Directory -Path $path -ErrorAction Stop return $path }catch{ if(-not (Test-Path -LiteralPath $path)){throw} } } } function Export-PSISitesReport($Model,$Meta,[string]$ModuleRoot,[string]$ReportFolder,[string]$TemplateName='SitesAndServices.html',[string]$ReportBaseName='Sites-And-Services'){ $schema=$Model.Schema;$data=$Model.Data $csvFolder=Join-Path $ReportFolder 'CSV';$null=New-Item -ItemType Directory -Path $csvFolder -Force $payload=[ordered]@{meta=$Meta;sections=$schema;data=$data;coverage=$Model.Coverage;raw=$Model.Raw} $json=$payload|ConvertTo-Json -Depth 30 -Compress $html=New-PSIInventoryDashboard $Meta $schema $data $Model.Coverage $ModuleRoot $ReportBaseName foreach($key in $schema.Keys){ $cols=@($schema[$key][1]);$rows=@($data[$key]);$path=Join-Path $csvFolder ($key+'.csv') if($rows.Count){ $rows | ForEach-Object{ $safe=[ordered]@{};foreach($c in $cols){$v=Get-PSISiteValue $_ $c;if($v -is [string] -and $v -match '^[=+@\-\t\r\n]'){$v="'"+$v};$safe[$c]=$v};[pscustomobject]$safe }|Select-Object -Property $cols|Export-Csv -LiteralPath $path -Encoding UTF8 -NoTypeInformation }else{('"'+($cols -join '","')+'"'+[environment]::NewLine)|Set-Content -LiteralPath $path -Encoding UTF8 -NoNewline} } $htmlPath=Join-Path $ReportFolder ($ReportBaseName+'.html');$jsonPath=Join-Path $ReportFolder ($ReportBaseName+'.json') $utf8=New-Object text.UTF8Encoding($true) [IO.File]::WriteAllText($htmlPath,$html,$utf8);[IO.File]::WriteAllText($jsonPath,$json,$utf8) [pscustomobject]@{HtmlReport=$htmlPath;JsonSnapshot=$jsonPath;CsvFolder=$csvFolder} } |