Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Tenant Media table data arrangement

Posted on by 63

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
    YUN ZHU 73,696 Super User 2024 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 63 on at
    RE: Tenant Media table data arrangement

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

  • DannyR Profile Picture
    DannyR 63 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 73,696 Super User 2024 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans