Hi ,



I have a requirement for rule creation as below:



There is a xml message received with following structure:



MessageID

MessageName

DateTime

SystemName



when messages start coming I need to apply rules such that if the first message is accepted and if the same message (i.e. with the same messagename, and ServerName) arrives within 4 hours discard those following messages.

The plan is to save the accepted message (the first message ariving in a sql server DB and when subsequent messages arrives to compare with the records and find out if there is a similar message (i.e. with the same messagename, and ServerName) and the time difference is < or = 4 hrs.and discard those messages.



any idea of how we can check the time diff. and apply this BTS rule?



Thanks in advance,

Hari.