Reg SiteProtector Database.

Hi,

 

I am having a big issue with SiteProtector Database.

I need to check whether the logs are getting updated or not
in
SiteProtector DB (SQL in my case).

[Of course we can check in SiteProtector Console by looking
at events]

Can anyone tell me how to check this directly in DB? (I am
not aware
much about SQL)

There contains (SQL) lots of tables and those are not
understandable
easily. What are the details about each table?

If any documents available kindly provide me regarding this
and
SiteProtector DB.

 

I am having RealSecure Network Sensor 7.0, SiteProtector 2.0
SP6.1 and
SiteProtector Database 2.0 SP 6.24.

 

Regards,

Jagadeeshan S

 

_______________________________________________
ISSForum mailing list
ISSForumatla-mm1.iss.net

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to ht
tps://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to
mod-issforumiss.net

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

hi Jagadeeshan:

What do you mean with " 
>the logs are getting updated or not in
 
>SiteProtector DB
" ? if you mean to check that events are getting stored
in the database, i
can give you a hand.

You should use the following query in order to check how
many new events
are in queue to be stored in DB

select count(processingflag) from sensordata1 where
processingflag!=3

You should use the following query in order to see the last
rowid number
stored in DB. If you re run the query after 1 minute, you
can see the
diference of rows and you can get the amount of events per
minute.

select max(rowid) from dbo.SensorData1

I hope that help´s you.

Atte

Juan Roa Salinas

"Jagadeeshan S" <jagadeeshan.sramcoinfotech.com> on Miércoles, 16 de Mayo
de 2007 at 7:47 -0400 wrote:
>Hi,
>
> 
>
>I am having a big issue with SiteProtector Database.
>
>I need to check whether the logs are getting updated or
not in
>SiteProtector DB (SQL in my case).
>
>[Of course we can check in SiteProtector Console by
looking at events]
>
>Can anyone tell me how to check this directly in DB? (I
am not aware
>much about SQL)
>
>There contains (SQL) lots of tables and those are not
understandable
>easily. What are the details about each table?
>
>If any documents available kindly provide me regarding
this and
>SiteProtector DB.
>
> 
>
>I am having RealSecure Network Sensor 7.0, SiteProtector
2.0 SP6.1 and
>SiteProtector Database 2.0 SP 6.24.
>
> 
>
>Regards,
>
>Jagadeeshan S



Juan Roa Salinas
IEI - SOC Senior Manager - ISS-Certified Specialist
(ISS-CS)
Phone: (56 2) 6403981, (56 9) 7486538
e-mail: jroaorion2000.com
web site: www.orion2000.com

Orion 2000 S.A. - Chile
Soluciones en Seguridad de la Informacion
Empresa certificada BS 7799:2002 | ISO 9001:2000
----------------------------------------------------
La informacion contenida en esta transmision es
confidencial, amparada por
secreto profesional y esta dirigida exclusivamente a el o
los
destinatarios indicados. Cualquier uso, reproduccion,
divulgacion o
distribucion por otras personas que su(s) destinatario(s)
esta
estrictamente prohibida.
Las opiniones expresadas en este correo son las de su autor
y no son
necesariamente compartidas o apoyadas por la compania.
---------------------------------------------------

_______________________________________________
ISSForum mailing list
ISSForumatla-mm1.iss.net

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to ht
tps://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to
mod-issforumiss.net

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