GREAT!!! Thank you!!!
The secret is that if SecChkID>500000 you have to go through CheckProducts!!! Thanks Again, Matteo ---------- Initial Header ----------- >From : "flak" [EMAIL PROTECTED] To : [EMAIL PROTECTED] Cc : "issforum" [EMAIL PROTECTED] Date : Mon, 30 Aug 2004 18:58:26 +0800 Subject : RE: [ISSForum] ISS CVE references > Sorry,it's my fault again.It is written by our DBA,not ISS. > > create FUNCTION sr_TagTranslate (@tagname varchar(80)) > RETURNS int > > AS > BEGIN > > > > declare @oldsecchkid int > declare @newsecchkid int > select @oldsecchkid=secchkid from securitychecks where tagname = @tagname > IF @oldsecchkid >= 500000 > BEGIN > select distinct @newsecchkid= secchkid from checkproducts > where productcheckname = @tagname > > END > else > select @newsecchkid= @oldsecchkid > If @newsecchkid is NULL > select @newsecchkid= @oldsecchkid > > > return @newsecchkid > > END > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, August 30, 2004 7:01 PM > To: flak > Cc: issforum > Subject: RE: [ISSForum] ISS CVE references > > > no, I dont have the TagTranslate() function... > > could someone send me the SQL code of the function? thanks!!! > > I've listed below the functions I have. > If someone knows whichone could translate the TagName or SeccChkID into the > correct xforce value, when SecChkID>=500000 would be a great help! > > > I have those User Defined Functions > > iss_CalcIPAddrFNC dbo 8/20/2004 5:37:34 PM > iss_CalcIPNbrFNC dbo 8/20/2004 5:37:27 PM > iss_FormatAgentIDnP dbo 8/20/2004 5:37:35 PM > iss_FormatIPsForSorting dbo 8/20/2004 5:37:35 PM > > > ------------------------------- ------------------------------- ------ Matteo Poropat mailto:[EMAIL PROTECTED] o.it http://www.genhome.org http://books.dreambook.co m/mefistofele74/genhome. html ------------------------------- ------------------------------- ------ _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
