web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Delete Event Log
Microsoft Dynamics SL (Archived)

Delete Event Log

(0) ShareShare
ReportReport
Posted on by Stacy Roach Leslie 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.... :)

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Stacy Roach Leslie Profile Picture
    Stacy Roach Leslie 305 on at

    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 on at

    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)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans