[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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: nyarlathothep@xxxxxxxxx [mailto:nyarlathothep@xxxxxxxxx]
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@xxxxxxx

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@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.