HI Venkat: We had the same problem , and the solution is very simple, use SQL queries , and later you can, for example make reports from excel, brio , or another reporting software.
Here are some code to extract data from the SensorData (between months, or days) Table and save in another instance of sql server (for performance , if you take the data directly from the sensordata database online the performance is very bad). --------------- Query ------------- (SensorData) SELECT SensorData.SensorDataID, SensorData.AlertDateTime, SensorData.SensorName, SensorData.AlertName, SensorData.AlertPriority, SensorData.SrcAddressName, SensorData.DestAddressName, SensorData.ProtocolID, SensorData.SourcePort, SensorData.SourcePortName, SensorData.DestPortName, SensorData.Objectname, SensorData.SensorAddress, SensorData.Username, SensorData.Alertcount FROM RealSecureDB.dbo.SensorData WHERE (SensorData.Sensorname like 'SENSORNAME%') AND (SensorData.AlertDateTime BETWEEN '2004-10-01 00:00:00' AND '2004-10-31 23:59:59') (SensorDataResponse) SELECT SensorDataResponse.SensorDataID, SensorDataResponse.ResponseTypeName FROM RealSecureDB.dbo.SensorDataResponse, RealSecureDB.dbo.SensorData WHERE (SensorDataResponse.SensorDataID=SensorData.SensorDataID) AND (SensorData.Sensorname like'SENSORNAME_%') AND (SensorData.AlertDateTime BETWEEN'2004-10-01 00:00:00'AND'2004-10-31 23:59:59') (SensorDataAVP) SELECT SensorDataAVP.SensorDataID, SensorDataAVP.AttributeName, SensorDataAVP.AttributeValue FROM RealSecureDB.dbo.SensorDataAVP, RealSecureDB.dbo.SensorData WHERE (SensorDataAVP.SensorDataID = SensorData.SensorDataID) AND (SensorData.Sensorname like 'SENSORNAME_%') AND (SensorData.AlertDateTime BETWEEN '2004-10-01 00:00:00' AND '2004-10-31 23:59:59') with this 3 tables you can make some reports with another database online but not in production. Hope that helps. Sorry for my english :) Juanuko -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Venkat Raman Govinda Raj Enviado el: Mi�rcoles, 05 de Enero de 2005 4:45 Para: [email protected] Asunto: [ISSForum] RE: Generating Reports > Hello all, > > I have recently installed the ISS SiteProtector, everything is working fine except the reports. I would like to how i can generate reports about the various events. I also came to know that a advanced reporting feature is available bu that requires a additional license which i don't have. Please let me know how i can generate the reports without any additional license. > > Please feel free to mail me at [EMAIL PROTECTED] > > Regards, > > G G Venkat Raman > > "Excellence is not a destination; it is a continuous journey that never ends." > > _______________________________________________ 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. _______________________________________________ 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.
