Gary, Purges should normally be scheduled using the automated database maintenance tool that is accessible from the RealSecure SiteProtector Console. However, if you need to initiate a purge manually, the procedures utilized by the maintenance tool may be invoked manually to perform the purge.
iss_PurgeAnalysisLog - Removes records from the AnalysisLog table. This table logs the queries performed during data analysis. iss_PurgeExceptions - Removes records from the Observances and SensorData tables. These records correspond to events that have been included in an exception. iss_PurgeHosts - Removes records from the Hosts table. These records correspond to the host objects that may be grouped and managed with the console. iss_PurgeIncidents - Removes records from the Observances and SensorData tables. These records correspond to events that have been included in an incident. iss_PurgeJobs - Removes records from the ActionJob, ActionDetails, and Schedule tables. These records correspond to the job entries seen in the console for hosts, grou ps, and sensors. iss_PurgeMaintenanceLog - Removes records from the MaintenanceLog table. This table logs all of the messages produced by the maintenance procedures. iss_PurgeMessageLog - Removes records from the MessageLog table. This table logs all of the errors and messages produced by the error trapping of the database procedures. iss_PurgeMetrics - Removes records from the Metrics table. These records correspond to the trending data seen in the dashboard console. iss_PurgeObs - Removes records from the Observances tables. These records correspond to the first level event information seen in the console. iss_PurgeSD - Removes records from the SensorData tables. These records correspond to the detailed information seen when drilling into events on the console. These procedures take one parameter. This value is the date before which all data will be deleted. For example, if you enter 1/1/2002, all data prior to 1/1/2002 will be deleted by the procedure. 1. Disable the automated maintenance process for the database. The automated maintenance process should not be used when manual purges are being performed. 2. Start the Microsoft SQL Server Query Analyzer tool. 3. Connect to the database server where the RealSecureDB is located. 4. Select the RealSecureDB database from the dropdown menu on the toolbar at the top of the Query Analyzer window. 5. In the query window enter the command for the type of data you wish to purge. For example, enter the following to purge SensorData: exec iss_PurgeSD '1/1/2001' 6. Press the F5 key and wait for the purge to complete. This could take a long time depending on how much data will be purged. In the above examples, replace the date with the date before which you would like all data to be purged. It is strongly recommended that you only invoke the purge procedures manually only when directed to perform this action by ISS Technical Support. In general, the most space will be made available by using the iss_PurgeSD procedure. Following that, the most space is likely to be made available by purging with the iss_PurgeObs and iss_PurgeHosts procedures. Finally, if you would like to attempt to shrink the database files, you can use the iss_ShrinkDB procedure. This procedure accepts no parameters and will attempt to release all of the free space at the end of the data file back to the operating system. This may not result in much, if any, reduction in the data file size. 1. Verify that the automated maintenance process for the database is disabled. 2. Start the Microsoft SQL Server Query Analyzer tool. 3. Connect to the database server where the RealSecureDB is located. 4. Select the RealSecureDB database from the dropdown menu on the toolbar at the top of the Query Analyzer window. 5. In the query window enter the following to shrink the database files: exec iss_ShrinkDB 6. Press the F5 key and wait for the shrink to complete. NOTE: The System Requirements for RealSecure state that it is important to have a person that can perform SQL-related tasks (i.e. SQL Database Administrator), because MSDE and SQL Server are more complicated to maintain than the Access database previously used by RealSecure. WARNING: Incorrectly configuring your database may cause severe and irreparable damage and may require you to reinstall your database and/or even worse, your entire system. Internet Security Systems cannot guarantee that problems resulting from the incorrect configuration of your database can be resolved. Configure your database at your own risk if you do not have the appropriate personnel/knowledge to do so. If you have questions or doubts about any of these procedures, STOP! If you are not your company's DBA, or if you do not have one, contact ISS Technical Support for assistance. Regards, Jim Howard Technical Support Engineer Internet Security Systems: http://www.iss.net Phone: 404.236.2700 or 1.888.447.4861 Technical Support Email: [EMAIL PROTECTED] Reduce your wait time! Activate your MyISS Customer Portal account. You can create, track and update support incidents online via the Customer Support Center. This provides you with an easy to use method for monitoring the progress of support incidents. MyISS Customer Portal Log-in: https://www.iss.net/issEn/MYISS/login.jhtml MyISS Customer Portal Log-in information: https://www.iss.net/issEn/MYISS/login_help.jhtml (Currently available in North America only) PGP Public Keys http://www.iss.net/support/howto_encrypted_email.php Training http://www.iss.net/education/ Internet Security Systems Product Knowledgebase http://www.iss.net/support/knowledgebase/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > -----Original Message----- > From: [EMAIL PROTECTED] On Behalf Of ISSAlerts > Sent: Thursday, April 08, 2004 4:53 PM > To: [EMAIL PROTECTED] > Subject: [ISSForum] Clearing Database Tables - SiteProtector > > > My database is pegged out from months of neglect. I just > started this job and need to shrink this database before I do > anything else. Does anyone know what tables I can purge and how? > > Gary > _______________________________________________ > 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.
