webui/cmcovstatus.ps1
|
$PageTitle = "ConfigMgr Coverage Status" $content = "" $menulist = "" $tabset = "" $pagelink = Split-Path -Leaf $MyInvocation.MyCommand.Definition function Write-SkPieChart2 { param ( [parameter(Mandatory=$True)] [string] $Title, [parameter(Mandatory=$False)] [int] $ChartWidth = 400, [parameter(Mandatory=$False)] [int] $ChartHeight = 250, [hashtable] $DataTable, [int] $ChartID = 1 ) try { $columnNames = $DataTable.Keys $cdata = '[' + $(($columnNames | %{ "'$_'" }) -join ',') + '],' $rowcount = $DataTable.Keys.Count $index = 0 $DataTable.Keys | %{ $cdata += "`n ['$_', $($DataTable.item($_))]" if ($index -lt $rowcount) { $cdata += "," } $index++ } if ($SkTheme -eq 'stdark.css') { $bgcolor = '#343e4f' $colors = "['red','blue','green']" $titleStyle = "{color: 'white'}" $legendStyle = "{color: 'white'}" } else { $bgcolor = '#fff' $colors = "['red','blue','green']" $titleStyle = "{color: 'black'}" $legendStyle = "{color: 'white'}" } $output = "<div id=`"piechart$ChartID`"></div> <script type=`"text/javascript`" src=`"https://www.gstatic.com/charts/loader.js`"></script> <script type=`"text/javascript`"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ $cdata ]); var options = { 'title':'$Title', 'width':$ChartWidth, 'height':$ChartHeight, 'backgroundColor': '$bgcolor', 'titleTextStyle': $titleStyle, 'legend': {textStyle: $legendStyle}, 'colors': $colors, 'pieHole': .5, 'is3D': false, 'sliceVisibilityThreshold': .2 }; var chart = new google.visualization.PieChart(document.getElementById('piechart$ChartID')); chart.draw(data, options); } </script>" } catch { $output = "<table id=table2><tr><td>Error: $($Error[0].Exception.Message)</td></tr></table>" } finally { Write-Output $output } } try { $adusers = Get-SkAdUsers $adgroups = Get-SkAdGroups $adcomps = Get-SkAdComputers $adusernum = $adusers.Count $adcompnum = $adcomps.Count $cmcomps = 0 $cmusers = 0 $cmcomps = Get-SkCmRowCount -TableName "v_R_System" -ColumnName "Name0" $cmusers = Get-SkCmRowCount -TableName "v_R_User" -ColumnName "User_Name0" $covdev = [math]::Round(($cmcomps / $adcompnum) * 100,2) $covusr = [math]::Round(($cmusers / $adusernum) * 100,2) $dataset1 = [ordered]@{ ADComputers = $adcompnum CMComputers = $cmcomps } $dataset2 = [ordered]@{ ADUsers = $adusernum CMUsers = $cmusers } $chart1 = Write-SkPieChart2 -Title "Device Coverage" -DataTable $dataset1 -ChartID 1 -ChartWidth 450 -ChartHeight 250 $chart2 = Write-SkPieChart2 -Title "User Coverage" -DataTable $dataset2 -ChartID 2 -ChartWidth 450 -ChartHeight 250 $content = "<table id=table2> <tr><td> <h3>Computers</h3> <table id=table2> <tr><td><a href=`"adcomputers.ps1?f=name&tab=All`">Active Directory</a></td><td style=`"text-align:right`">$adcompnum</td></tr> <tr><td><a href=`"cmdevices.ps1?tab=All`">Configuration Manager</a></td><td style=`"text-align:right`">$cmcomps</td></tr> <tr><td>Coverage State</td><td style=`"text-align:right`">$covdev`%</td></tr> </table> </td> <td> <h3>User Accounts</h3> <table id=table2> <tr><td><a href=`"adusers.ps1?f=username&tab=All`">Active Directory</a></td><td style=`"text-align:right`">$adusernum</td></tr> <tr><td><a href=`"cmusers.ps1?tab=All`">Configuration Manager</a></td><td style=`"text-align:right`">$cmusers</td></tr> <tr><td>Coverage State</td><td style=`"text-align:right`">$covusr`%</td></tr> </table> </td></tr> <tr> <td>$chart1</td> <td>$chart2</td> </tr> </table>" } catch { $content = "<table id=table2><tr><td>Error: $($Error[0].Exception.Message)</td></tr></table>" } Write-SkWebContent |