web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 101

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 89,974 Super User 2025 Season 2 on at
    RE: Tenant Media table data arrangement

    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

  • DannyR Profile Picture
    DannyR 101 on at
    RE: Tenant Media table data arrangement

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

  • DannyR Profile Picture
    DannyR 101 on at
    RE: Tenant Media table data arrangement

    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)

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 89,974 Super User 2025 Season 2 on at
    RE: Tenant Media table data arrangement

    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

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,737 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,577

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,251

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans