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: nyarlathothep@libero.it [mailto:nyarlathothep@libero.it]
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
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security Systems,
6303 Barfield Road, Atlanta, Georgia, USA 30328.
