TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Hi Brian,
thanks for the CLI procedure. However it does not work in my
environment:
E:\MSSQL7\BINN>osql -E
1> use ISSED
2> go
1> iss_purgeevents '1/1/2001 00:00:00','9/30/2001 00:00:00',1000
2> go
Meldung 8114, Ebene 16, Status 4, Server KJLAPTOP, Prozedur
iss_PurgeEvents, Zeile 0
[Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren
von Datentyp varchar in datetime.
comment-1:
the error message (German!) says that it cannot convert the data type in
datetime. Same message appears when issuing the command from the WGM
GUI. WGM is
installed on NT 4.0 SP6a with MS SQL7. All other functions incl DB sync
are just fine and reports
do work. I believe the problem came up because the old RS data have been
loaded into the
database during installation, but this is just a guess. To get rid of
this type of
problem you have to use sql commands rather than stored procedures, e.g.
delete all records from
the associated tables. Could you come up with an howto for this kind of
corrupted data scenario? I
think the ISS Community would be interested in such a procedure as
loaded databases are still an
issue. We already used sql commands in an EM SQL environment for getting
rid of corrupted asset database
(due to "bad installation history"). This did work (SQL is just great).
comment-2:
Bob was faster, thank you! (I knew ISS must have thought of this
problem).
Karl
quoted email:
Betreff: RE: RS 6.0 Database
Datum: Thu, 25 Oct 2001 09:03:23 +0100
Von: "Shih, Robert" <[EMAIL PROTECTED]>
An: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message
to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
problems!
----------------------------------------------------------------------------
Hi,
*** UNDOCUMENTED COMMAND. RUN IT AT YOUR OWN RISK. ALWAYS TEST ON DEV
FIRST. ***
- shutdown console
In "RealSecure 6.0 Console" directory
osql -E
use issed
go
exec iss_truncateevents
go
exit
- then restart iss/sqlserver or better to reboot. This should clear the
Event Database.
Regards.
Bob Shih
"Fitch, Brian (ISS Atlanta)" schrieb:
>
> TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
> [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
> ----------------------------------------------------------------------------
>
> Hi,
>
> If you're using MSDE:
>
> The format is for the purge procedure is:
>
> >From the Binn directory under the MSSQL directory at a command line enter:
>
> osql -E <ENTER>
>
> 1> use ISSED <ENTER>
> 2> go <ENTER>
>
> 1> iss_purgeevents '1/1/2001 00:00:00','12/31/2001 00:00:00',100 (or
> whatever date range is relevant)<ENTER>
> 2> go <ENTER>
>
> If you're using SQL, use Enterprise Manager.
>
> Brian Fitch, Named Accounts Engineer, Internet Security Systems, Inc.
>
> -----Original Message-----
> From: Luis Javier Perez [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: RS 6.0 Database
>
> TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
> [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
> problems!
> ----------------------------------------------------------------------------
>
> Hi everyone
>
> Is there any way to clear all the database from the RealSecure 6.0 Console,
> or any other way???
> I have Console and Event Collector on the same machine..
>
> any suggestion will be appreciated..
--
-------------------------
BDG GmbH & Co.KG
Make IT Safe!
Wendelinstrasse 1
50933 Köln
Germany
Tel: +49+221/954231-0
Fax: +49+221/954231-31
eMail: [EMAIL PROTECTED]
Web: www.bdg.de
-------------------------
