![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
![]() |
Reported By: Tiago Ameller Reported On: 4/1/2009 For: Version 2.02 Build 10 |
/* Export today's server log to csv */ SCRIPT () BEGIN EXECUTE IMMEDIATE ' CREATE TEMPORARY TABLE TODAYS_LOG AS SELECT "LOGTIMESTAMP", "USER", "CATEGORY", "FUNCTION", "DESCRIPTION" FROM CONFIGURATION.LOGEVENTS WHERE LOGTIMESTAMP BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL "1" DAY WITH DATA'; EXECUTE IMMEDIATE 'EXPORT TEMPORARY TABLE TODAYS_LOG TO "TODAYS_LOG.CSV" IN STORE CLIENTS DELIMITER CHAR '';'' DATE FORMAT ''DD/MM/YYYY'' TIME FORMAT ''HH:MM:SS'' DECIMAL CHAR '','' INCLUDE HEADERS'; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |