Welcome
Guest!
Register
|
Login
|
Login Assistance
Extending your Citrix and Terminal Server
environment using .NET and other technologies.
Home
Articles
Downloads
Links
About
Lab
Visual MFCOM
Categories
Citrix Access Gateway (1)
Citrix Clients (3)
Citrix Presentation Server (27)
Customization (14)
Databases (18)
Management (7)
MFCOM (5)
Resource Manager (13)
Scripting (2)
Silverlight (1)
Tweaks (4)
Web Interface (9)
Xen (1)
Recommended Sites
Terminal Server Consultants
Access VBA training
Sponsored Links
Project S-Bend Setup Instructions
Published: January 14, 2008 | Modified: January 22, 2008
Note: The setup instructions and screenshots shown below are for use with Microsoft SQL Server 2005. However, the steps are similar for Microsoft SQL Server 2000.
Download Project S-Bend Phase I
Step 1 – Set up the Database
Open SQL Server Management Studio (or SQL Enterprise Manager for SQL 2000).
Right click on your Citrix Configuration Logging database and select "New Query".
In the Query window paste the following SQL Script:
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [trig_ChangeAlert] ON [dbo].[CtxLog_AdminTask_LogEntry] AFTER INSERT AS BEGIN SET NOCOUNT ON; declare @LogEntry_RecordID int SELECT @LogEntry_RecordID = LogEntry_RecordID FROM INSERTED INSERT INTO Alerts (LogEntry_RecordID) VALUES (@LogEntry_RecordID) END GO CREATE TABLE [dbo].[Alerts]( [LogEntry_RecordID] [int] NOT NULL, [Processed] [bit] NOT NULL CONSTRAINT [DF_Alerts_Processed] DEFAULT ((0)), CONSTRAINT [PK_Alerts] PRIMARY KEY CLUSTERED ([LogEntry_RecordID] ASC) ) ON [PRIMARY] GO
Press F5 to execute the query. This will create the Alerts table and the SQL Trigger.
Step 2 – Set up the Windows Service
Copy the following files to your preferred destination directory (something like C:\Program Files\CitrixConfigAlert\):
CtxConfigAlert.exe
CtxConfigAlert.exe.config
Edit CtxConfigAlert.exe.config with the appropriate values for your environment. Set values for the following:
connectionString
- Tip: visit
www.connectionstrings.com
for help with this value.
PollInterva
l - This is how often (in seconds) the Windows Service will poll the Alerts table.
MailToAddress
- The destination email address to send the alerts.
SMTPServer
- The name or IP address of your SMTP server.
SMTPPort
- The port of your SMTP server (defaults to 25).
MailSubject
- This will be the subject line of the email sent.
MailFromAddress
- The email address used to send the alert.
Step 3 - Install the Windows Service
Open a command prompt and change the directory to C:\Windows\Microsoft.NET\Framework\v2.0.
x
Perform the following command:
InstallUtil /I
path_to_CtxConfigAlert.exe
This will install a new Windows Service called "Citrix Change Alerts (S-Bend)".
Start the service.
Any errors that occur while starting the service, or during the operation of the service, will be logged to the Windows Application event log.
Note: Changes made to CtxConfigAlert.exe.config require a service restart to take effect.
Published:
January 14, 2008
Last Modified:
January 22, 2008
Tags:
Citrix Presentation Server
Databases
Management
Current Rating:
This post has not been rated.