Find the database hosting XenDesktop Datastore

To find the database server hosting the XenDesktop database, log on to the Desktop Delivery Controller server

Open  PowerShell in admin mode and type the below commands


The Server field gives you name of the database server, Initial Catalog is the database name and Integrated Security is the security type

Hope this helps.


Published Applications Report in Excel using Powershell

Here is a PowerShell script to extract the published applications in a CSV file. This script could be used for XenApp 6.0 or above farms . I do not own the script so please use this at your own risk.


# Create variables

asnp citrix*

$outpath = [environment]::getfolderpath(“mydocuments”) + “\XenApp_Published_App_Report.csv”

$xaapplist = get-xaapplication

$appreport=foreach ($application in $xaapplist)

{get-xaapplicationreport -BrowserName $application.BrowserName}

# pipe appreport variable and select required objects for output

$appreport |

select-object BrowserName,



@{n=’accounts’; e={$_.accounts}},@{n=’servernames’; e={$_.servernames}},@{n=’workergroupnames’; e={$_.workergroupnames}},folderpath,commandlineexecutable,clientfolder,





colordepth |

#Export results to a CSV

export-csv $outpath


The original source of the script could be found here