Rich, You'll find the database schema in Appendix A of "SiteProtector Reference Guide Version 2.0, SPxx". This PDF available from the ISS download area under product documentation. The existing stored procedures are a good starting point on how to access data.
Cheers, RObert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rohrich Sent: 17 November 2004 19:08 To: [EMAIL PROTECTED] Subject: [ISSForum] Site Protector Database structure Is there any current documentation available about the database structure of Site Protector? I've waded into this huge SQL database, but it looks like it will be a lot of work figuring this out. The lableing of the fields doesnt appear to always match what is displayed and although it looks like SensorData is the table where most of the information is, it looks like i need to look at other tables as well. Before I plow through this has anyone already found a datamap or been through all this work already? I'd like to use Crystal reports to prepare some very specific reports that aren't available on the SiteProtector console. Regards, Rich Rohrich _______________________________________________ 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.
