How to enable hidden dashboards

Applies to: Gizmo 1.8+ | On-Premises

This should be done on the Windows Server machine hosting Gizmo and only applies when Database connection relies on SQL Authentication.

Instructions

  1. Open a PowerShell editor (e.g. PowerShell ISE) as Administrator.

  2. Edit the top lines of below scripts depending on the dashboards you wish to enable.

    $queries = New-Object System.Collections.ArrayList
    
    # Enable SkypeForBusiness Dashboard
    $queries.add("UPDATE WebUi_Dashboards SET Active = 1 WHERE [DashboardGuid] = 'CB5533AE-9312-4EFE-B4F2-2C074EDD35AB'")
    # Mail Routing Hybrid
    $queries.add("UPDATE WebUi_Dashboards SET Active = 1 WHERE [DashboardGuid] = '31B8A1AC-1BC6-4169-942B-F74A0DF57233'")
    
    
    # Get connection info
    $GsxSolutionsRegistryKey = 'HKLM:\SOFTWARE\GSX Solutions'
    $ScanConfigRegistryKey = Join-Path $GsxSolutionsRegistryKey -ChildPath "Scan Configuration Microservice"
    $Configuration = New-Object -TypeName PSObject
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQHostname -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name hostname)
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQPassword -Value ([System.Text.Encoding]::UTF32.GetString([System.Convert]::FromBase64String((Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name Password))))
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQPort -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name Port)
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQVirtualHostname -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name VirtualHostname)
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQUsername -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name Username)
    $Configuration | Add-Member -MemberType NoteProperty -Name RabbitMQUseSsl -Value ([Convert]::ToBoolean((Get-ItemPropertyValue ("$ScanConfigRegistryKey\busconfig\") -Name UseSsl)))
    $Configuration | Add-Member -MemberType NoteProperty -Name SQLDataSource -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\dbconfig\") -Name DataSource)
    $Configuration | Add-Member -MemberType NoteProperty -Name SQLDatabase -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\dbconfig\") -Name Database)
    $Configuration | Add-Member -MemberType NoteProperty -Name SQLPassword -Value ([System.Text.Encoding]::UTF32.GetString([System.Convert]::FromBase64String((Get-ItemPropertyValue ("$ScanConfigRegistryKey\dbconfig\") -Name Password))))
    $Configuration | Add-Member -MemberType NoteProperty -Name SQLUserID -Value (Get-ItemPropertyValue ("$ScanConfigRegistryKey\dbconfig\") -Name UserID)
    $Configuration | Add-Member -MemberType NoteProperty -Name SQLUseWindowsCredentials -Value ([Convert]::ToBoolean((Get-ItemPropertyValue ("$ScanConfigRegistryKey\dbconfig\") -Name UseWindowsCredentials)))
    $Configuration
    
    foreach ($query in $queries) {
        Write-host 'Executing '$query
        Invoke-Sqlcmd -ServerInstance $Configuration.SQLDataSource -Database $Configuration.SQLDatabase -Query $query -Username $Configuration.SQLUserID -Password $Configuration.SQLPassword
    }
    
    
  3. Run