Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Tenant Media table data arrangement

(0) ShareShare
ReportReport
Posted on by 73

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

  • Verified answer
    YUN ZHU Profile Picture
    81,912 Super User 2025 Season 1 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
    73 on at
    RE: Tenant Media table data arrangement

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

  • DannyR Profile Picture
    73 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
    81,912 Super User 2025 Season 1 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

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,351 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans