Citrix XenApp Session Dump to SQL

Rating: No reviews yet
Downloads: 86
Released: Jun 6, 2013
Updated: Jun 6, 2013 by icefyre
Dev status: Stable Help Icon

Recommended Download

Application CXA6xSession2SQL.ps1
application, 2K, uploaded Jun 6, 2013 - 86 downloads

Release Notes

Introduction

CXA6xSession2SQL is a Script to collect Citrix XenApp sessions and write that info to a SQL DB.

Usage

Before using script, create a DB and a table. Within the table create the fields with the selections in the script. For the exception of the date fields use text data. The date fields use smallDate data. Also edit the connectionstring variable with your SQL connection info.
Ideal scenario is to schedule it to run every 15mins. You can use a ASP website to read the data from the SQL DB.
I'll document an example of How To achieve this in the Documentation section.

Tested with Windows 2008R2 and Citrix XenApp 6.0 & 6.5.


NOTE 1:The account used to execute the Script must have elevated privileges.
NOTE 2:PowerShell execution policy should be set to RemoteSigned.

Reviews for this release

No reviews yet for this release.