And don't forget any functions your database has. Oracle has HASH, ENCRYPT, ...
You can use them with a simple SQL Set fields action. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Friday, December 02, 2011 4:03 AM To: [email protected] Subject: Re: Hash/encryption functions in ARS Hi Alex, This sounds like a good job for a Filter Plugin. You can write it in C or in Java. You can also, even if it is not the most elegant solution, call an external program on your server to do this. Filter: Action: Set-Fields: CURRENT TRANSACTION md5field = $PROCESS$ echo $USER$ my secret | md5sum Action: Set-Fields: CURRENT TRANSACTION md5field = LEFT($md5field$, 32) I added another action to trim the field to 32 characters. If you are on Windows, you should be able to do a very similar thing. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. -----Original Message----- > Hello. > > I'm looking for the some hash/encryption function in ARS which is > compatible with some external one. I want to add som link from ARS to > the external WEB application, but in this application I have to be > sure that user come from ARS system (some sort of authorization). F.e. > > http://my-application/login?user=USER&ars_secret_code=<ARS SECRET CODE>. > > The problem is that I can't find a way to compute <ARS SECRET CODE> on > ARS server. In the simpliest case it could be just MD5('some secret > string' + arsystem.userid), but it seems that there is no MD5 function > in Remedy. > > We found some ENCRYPT/DECRYPT function, but right now I don't > understand which algoritm is used and can't use the same > encryption/dectyption algoritm in external application. > > Could anybody help me? Probably there is some other way to integrate > external WEB link into Remedy application? > > Alex Bakhtin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
