Recover database space by deleting audit logs - Power Platform (2024)

  • Article

When you enable auditing, customer engagement apps (Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Marketing, and Dynamics 365 Project Service Automation), store the change history for transactions in the form of audit logs in the database. You can delete old or unwanted logs to restore database space. You can choose to delete audit logs by table, by access logs, or by date range.

Find out audit storage by table

To assist you in determining which audit logs to delete, we have created the GetAuditStorageDetails Action where you can get audit storage sizes by table.

Using a tool like Insomnia, you can retrieve the audit storage information.

Request

POST [Organization Uri]/api/data/v9.2/GetAuditStorageDetailsAccept: application/jsonContent-Type: application/json; charset=utf-8OData-MaxVersion: 4.0OData-Version: 4.0

Response

 HTTP/1.1 200 OK Content-Type: application/json; odata.metadata=minimal OData-Version: 4.0 { "@odata.context": [Organization Uri]/api/data/v9.1/$metadata#Microsoft.Dynamics.CRM.GetAuditStorageDetailsResponse, "Result": { "Status": "Completed", "AuditStorageDetails": { "Count": 3, "Keys": [ "organization", "deletedentity_10928", "new_entity_02272411082222785" ], "Values": [ { "SizeInBytes": 3835, "ObjectTypeCode": 1019 }, { "SizeInBytes": 3113, "ObjectTypeCode": 10928 }, { "SizeInBytes": 2012, "ObjectTypeCode": 10990 } ] } } }

Caution

When you delete an audit log, you can no longer view the audit history for the period covered by that audit log. Deleted logs are not recoverable.

  1. Open the Power Platform admin center as a system administrator.

  2. In the navigation pane, select Environments.

  3. Select an environment.

  4. In the Auditing section, under Free up capacity, select Delete audit logs.

  5. In the Select logs to delete pane, select one of the following options:

    • By table
    • Access logs, by people and systems
    • All logs up to and including the selected date.
  6. Select Delete.

    Note

    You can only delete the oldest audit log in the system. To delete more than one audit log, continue to delete the oldest audit log until you have deleted enough logs.

See also

Manage Dataverse auditing
Dataverse developer guide: Delete audit data

Recover database space by deleting audit logs - Power Platform (2024)

FAQs

Recover database space by deleting audit logs - Power Platform? ›

You can only delete the oldest audit log in the system. To delete more than one audit log, continue to delete the oldest audit log until you have deleted enough logs.

Can we delete audit logs? ›

You can only delete the oldest audit log in the system. To delete more than one audit log, continue to delete the oldest audit log until you have deleted enough logs.

How do I delete the audit summary view in Dynamics 365? ›

In this article
  1. Make sure that you have the System Administrator or System Customizer security role or equivalent permissions. Check your security role. ...
  2. Go to Settings > Auditing.
  3. Choose Audit Log Management.
  4. Select the oldest audit log. Then, on the command bar, choose Delete Logs.
  5. In the confirmation message, choose OK.
Feb 15, 2022

How to restore Power Platform environment? ›

Go to Environments, select an environment, and then select Backups & Restore > Restore or manage. On the Manual tab, select a manual backup to restore, and then select Restore. Select whether you want to include audit logs.

How an audit log can be used as recovery tool? ›

Recovering Data

With the Audit Log you can reduce the risk of data loss and handle such cases on your own, quickly and easily. You can find the deleted Records in a Form, Folder or in the entire Database and review which user deleted them and when.

What are the disadvantages of audit logs? ›

Disadvantages of Audit Trails A further concern is when computerized audit logs are used that automatically record all transactions; if anyone is given access to the logs, then transactions can be modified or deleted, obscuring what actually happened and making it much easier to commit fraud.

How do I clear my server audit log? ›

On the Server Auditing page, click Delete All Logs to delete all logged audit events. A confirmation window is displayed. Click Delete to confirm deleting all logged audit events.

How do you handle audit logs? ›

  1. Set IAM permissions. ...
  2. Configure log views. ...
  3. Set log field-level access controls. ...
  4. Choose where your logs are stored. ...
  5. Define data retention periods. ...
  6. Protect your audit logs with customer-managed encryption keys. ...
  7. Understand data format in sink destinations. ...
  8. Copy log entries.

How do I delete audit logs in Dataverse? ›

JayeshKumar Pawar
  • Overview:
  • 📋 Steps:
  • Access the Audit History Tab: Navigate to the audit history tab for the specific record you wish to manage.
  • Delete Change History: Within the audit history tab, locate the "Delete Change History" button. ...
  • 🔒 Access Control:
  • 🤖 Automation:
Oct 16, 2023

What is the retention period of audit logs in Dynamics 365? ›

The default retention period for Audit (Standard) has changed from 90 days to 180 days. Audit (Standard) logs generated before October 17, 2023 are retained for 90 days. Audit (Standard) logs generated on or after October 17, 2023 follow the new default retention of 180 days.

Where to store audit logs? ›

While audit logs can take the form of a physical file, the term usually refers to digital records that you can store in a log management platform.

How to view power platform logs? ›

Access the logs
  1. Sign into the Microsoft Purview compliance portal as a tenant admin.
  2. In the left hamburger menu, select Show all.
  3. Select Audit from the Solutions category.
Dec 15, 2023

How do I clear the cache in Power Platform? ›

Steps to Clear Cache while Working with Power Apps Portals
  1. [Portal User With Administrator role inD365]
  2. [Log in the portal by Admin user] Navigate to the URL as follows: /_services/about.
  3. After this, the portal details page will be open. Click on the Clear Cache button to clear the cache.

How do I recover deleted solutions from Power Platform? ›

Restore Deleted Power Apps
  1. Signin to Power Platform Environment : Add-PowerAppsAccount.
  2. Run the code to list out all the deleted Power apps.
  3. Get the Power App Name from the listing which you want to restore.
  4. Run the code to restore the Power app.
  5. Check the Power App Portal.

How to restore deleted records in Dynamics 365? ›

You can do this by clicking the 'Restore Deleted' button, which will bring up a list of all the deleted records, from which you can select the desired record and click the 'Restore' button to retrieve it. Bingo! Your desired record will be restored quickly.

Can you clear audit log in QuickBooks? ›

Select "Condense data" if you are working with a version of QuickBooks 2000 or earlier, and you are finished. For versions of QuickBooks after 2000, select "Clean up Company Data." Select either the date ranges for which you want to clear the audit trail or the option to delete all transactions.

Can you delete an audit trail? ›

Select Setup > System > Processes > Delete Audit Trail Records. Click the File button and select the files containing the audit trail records you want to delete.

Can we delete audit trail? ›

If the audit trail target is or was a database table, you can delete old audit entries, for example to prevent the audit table from growing indefinitely. You can do this using the Security editor of the SAP HANA studio.

How long should audit logs be kept? ›

For example, you may keep audit logs and firewall logs for two months. However, if your organization must follow strict laws and regulations, you may keep the most critical logs anywhere between six months and seven years. This timeframe is the log retention period.

Top Articles
Carpal Bones Mnemonic
Jam proofing drones
Avonlea Havanese
Access-A-Ride – ACCESS NYC
Unity Stuck Reload Script Assemblies
The Ivy Los Angeles Dress Code
Minn Kota Paws
Tugboat Information
Ave Bradley, Global SVP of design and creative director at Kimpton Hotels & Restaurants | Hospitality Interiors
Wunderground Huntington Beach
Www.paystubportal.com/7-11 Login
Obituary | Shawn Alexander | Russell Funeral Home, Inc.
Slag bij Plataeae tussen de Grieken en de Perzen
Marion County Wv Tax Maps
Healing Guide Dragonflight 10.2.7 Wow Warring Dueling Guide
Animal Eye Clinic Huntersville Nc
Foodland Weekly Ad Waxahachie Tx
Crossword Nexus Solver
Nba Rotogrinders Starting Lineups
Divina Rapsing
Parentvue Clarkston
Contracts for May 28, 2020
Shreveport City Warrants Lookup
Low Tide In Twilight Ch 52
Surplus property Definition: 397 Samples | Law Insider
Dei Ebill
Craigslist Rentals Coquille Oregon
When His Eyes Opened Chapter 3123
Phoenixdabarbie
Log in to your MyChart account
Miller Plonka Obituaries
Dairy Queen Lobby Hours
Plasma Donation Racine Wi
Scat Ladyboy
Que Si Que Si Que No Que No Lyrics
Panchang 2022 Usa
Movies123.Pick
Cvb Location Code Lookup
Bitchinbubba Face
Infinite Campus Parent Portal Hall County
Final Fantasy 7 Remake Nexus
Lcwc 911 Live Incident List Live Status
Walmart Pharmacy Hours: What Time Does The Pharmacy Open and Close?
Gt500 Forums
Gonzalo Lira Net Worth
Tito Jackson, member of beloved pop group the Jackson 5, dies at 70
Horseneck Beach State Reservation Water Temperature
Westport gun shops close after confusion over governor's 'essential' business list
Adams County 911 Live Incident
Latest Posts
Article information

Author: Tuan Roob DDS

Last Updated:

Views: 6642

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Tuan Roob DDS

Birthday: 1999-11-20

Address: Suite 592 642 Pfannerstill Island, South Keila, LA 74970-3076

Phone: +9617721773649

Job: Marketing Producer

Hobby: Skydiving, Flag Football, Knitting, Running, Lego building, Hunting, Juggling

Introduction: My name is Tuan Roob DDS, I am a friendly, good, energetic, faithful, fantastic, gentle, enchanting person who loves writing and wants to share my knowledge and understanding with you.