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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Tenant Media table dat...
Small and medium business | Business Central, N...
Answered

Tenant Media table data arrangement

(0) ShareShare
ReportReport
Posted on by DannyR 123

Hi Grus,

Current my online Business Central version is 21 and will be update to 22 early May and I am "Super" user.

I have used the BC from September last year and now the "Tenant Media" and "Tenant Media Thumbnails" tables size goes to 25GB now.

I'd like to know the way for data arrangement way like only be left vendor's invoice etc. If there is no way for filtered data deleting then please let me know entire table data delete way if it possible.

pastedimage1682370035499v1.png

I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 99,084 Super User 2026 Season 1 on at

    Hi, In BC22 Microsoft released a new method to solve this problem.

    More details:

    https://marketplace.visualstudio.com/items/ms-dynamics-smb.al/changelog

    pastedimage1682379206776v1.png

    pastedimage1682379273667v2.png

    For details, you can refer to What's new in VS Code and AL session in BC Launch Event.

    https://hopin.com/events/business-central-launch-event-4eb37891-3940-40a3-a49d-b48c6350c82d

    pastedimage1682379413945v3.png

    Hope this helps.

    Thanks.

    ZHU

  • DannyR Profile Picture
    DannyR 123 on at

    Hi ZHU, Thank you for your information.

    Regarding the newly will published "Media.FindOrphans & MediaSet.FindOrphans", I am not sure but I think it's only work for no more referenced media data cleanup. And if some no referenced Tenant Media data is automatically deleted in the system of current version also.  How can I find the Tenant Media data reference information? (learn.microsoft.com/.../devenv-working-with-media-on-records)

  • DannyR Profile Picture
    DannyR 123 on at

    learn.microsoft.com/.../devenv-working-with-media-on-records

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 99,084 Super User 2026 Season 1 on at

    Hi, Yes, the above method just removes unnecessary data.

    I discussed how to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media” in the following blog and hope it will give you some tips.

    https://yzhums.com/26326/

    Thanks

    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans