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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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 [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.
