Citrix CVAD Delivery Controller Show the SQL Database Server

 Use PowerShell CLI to show Citrix Broker database server name. 

PS C:\> Add-PSSnapin Citrix*

PS C:\> Get-ConfigDBConnection

Your output will show the database server name. If it's a cluster SQL server environement, you will see the cluster name. 

 An additional powershell command to display all commands related to the DB connection is 

 PS C:\> Get-Command Get-*DBConnection | Get-Unique | Select Nam

The result of the command is a list of useful CLI powershell commands:

Name

----

Get-AcctDBConnection
Get-AdminDBConnection
Get-AnalyticsDBConnection
Get-AppLibDBConnection
Get-BrokerDBConnection
Get-ConfigDBConnection
Get-EnvTestDBConnection
Get-HypDBConnection
Get-LogDBConnection
Get-MonitorDBConnection
Get-OrchDBConnection
Get-ProvDBConnection
Get-SfDBConnection
Get-TrustDBConnection

Turn off Location Services -Windows 10 how To

Turn on or Turn off Location Services

Use the registry Turn on or Turn off Location Services

You may want to turn off location services ion your desktop for whatever reason. For example, an application is not responding as it should because it's picking up a location that is then causing it to not function as it should. the application could be getting the wrong information or mistranslated it.  

Even if you turn location services off using the UI in windows. the user Interface allowed you to turn on or off location services however, that will be for the user that is logged in. So, with the local machine setting not changed, location services are still working.  Location services may be on in general for the operating system (the computer laptop or desktop). 

There are two registry location which are important for turning off location services. One is for the user that's logged in. This is a user level settings applied to the user. There is also a machine setting which will apply to the desktop or laptop in general. 

Set Deny in the following registry locations to disable or turn off Location services.

user settings

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\CapabilityAccessManager\ConsentStore\location

computer setting

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\CapabilityAccessManager\ConsentStore\location