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

RE: [ISSForum] ISS CVE references



GREAT!!!

Thank you!!!

The secret is that if SecChkID>500000 you have to go through CheckProducts!!! 

Thanks Again,

Matteo

---------- Initial Header -----------

>From      : "flak" flak@xxxxxxxxxx
To          : nyarlathothep@xxxxxxxxx
Cc          : "issforum" issforum@xxxxxxx
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: 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
> 
> 
> 


-------------------------------
-------------------------------
------
Matteo Poropat
mailto:nyarlathothep@liber
o.it
http://www.genhome.org
http://books.dreambook.co
m/mefistofele74/genhome.
html
-------------------------------
-------------------------------
------


_______________________________________________
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.