Documentation - Data Store, in the Citrix XenApp / Presentation Server forum on BrianMadden.com

Try this script. Just copy and paste it into a .VBS file and run it from one of your servers. And don't forget to vote! :)


' Created by Dan Murray, August 26, 2005

' This script displays the current Farm, DataSourceName and database
' being used the current server.

Const HKEY_LOCAL_MACHINE = &H80000002

strComputer = "."

Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\default:StdRegProv")

' Get the Farm name and DataSourceName environment variable for this server.

strKeyPath = "Software\Citrix\IMA"
strEntryName = "Neighborhood"
objReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strEntryName,strFarmName
strEntryName = "DataSourceName"
objReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strEntryName,strDataSourceName

' Display the current Farm name and DataSourceName

WScript.Echo "Current Farm: "& strFarmName
WScript.Echo "Current DataSourceName: "& strDataSourceName

Const ForReading = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile(strDataSourceName, ForReading)
Do While objTextFile.AtEndOfStream <> True
strLinetoParse = objTextFile.ReadLine
if Left(strLinetoParse, 7) = "SERVER=" then Wscript.Echo strLinetoParse
if Left(strLinetoParse, 9) = "DATABASE=" then Wscript.Echo strLinetoParse
Loop
objTextFile.Close

Thanks for the response Dan.

I tried it out on a couple of farms and I had success on a farm that used a SQL DB for a data store and the servers connected with DSNs.

But on farms that use MSDE and where the servers are connected directly to the server with the MSDE data store on it it gives me a script error.

I am just trying to find a tool that will tell me what type of Data Store (Access/MSDE/SQL) is being used and where it resides.

Thanks again.

Gotta love when there is no design documentation.

Thanks man, you just saved my day! Script works like a charm.