Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Delete Event Log

Posted on by 305

We have a massive amount of data in our Event Log file (SL- version 7.0).  Is there any way to delete the data & if so, what effect will it have on our system/data?

Thank you,

-Stacy Leslie

Lost Accountant.... :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Delete Event Log

    There are a lot of different ways to delete the files.  We use an SSIS package for SQL that is scheduled by SQL Agent that deletes the files and the records from pstatus.  The statement for the pstatus delete is

    delete from pstatus where execdate < (getdate()-14)

  • Stacy Roach Leslie Profile Picture
    Stacy Roach Leslie 305 on at
    Re: Delete Event Log

    Dwight,

    Thank you for the quick response.  Yes I believe that it is in the DSL root directory.  Is there an easy way to delete the log files?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Delete Event Log

    I assume you are talking about the eventlog folder in the DSL root directory.  We delete enything over 2 weeks old.  We also delete the records from the PSTATUS table for the associated eventlogs.  This way it keeps the users list of eventlogs shorter and we do not get the message that it can not find the file.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans