webui/cmproducts.ps1
|
Get-SkParams $PageTitle = "CM Installed Software" if (![string]::IsNullOrEmpty($Script:SearchValue)) { $PageTitle += ": $($Script:SearchValue)" } $content = "" $menulist = "" $tabset = "" $pagelink = "cmproducts.ps1" $queryfile = "" try { $params = @{ Query = "select distinct productname0 as ProductName, productcode0 as ProductCode, productversion0 as Version, publisher0 as Publisher, count(*) as Installs from v_GS_INSTALLED_SOFTWARE_CATEGORIZED group by productname0, productcode0, productversion0, publisher0" PageLink = $pagelink Columns = ('ProductName','Version','Publisher','ProductCode','Installs') Sorting = 'ProductName' } $content = Get-SkQueryTableMultiple @params $tabset = Write-SkMenuTabSetAlphaNumeric -BaseLink "$pagelink`?x=begins`&f=productname`&v=" -DefaultID $TabSelected $content += Write-SkDetailView -PageRef $pagelink -Mode $Detailed } catch { $content = "<table id=table2><tr><td>Error: $($Error[0].Exception.Message)</td></tr></table>" } finally { Write-SkWebContent } |