web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Retrieving Object Name...

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

Suggested Answer

Retrieving Object Name via SQL in BC

(0) Share

Report

Report

Posted on by Community Member

Dear All,

Need assistant on Object name. I am using Jetreport to query BC to build user permission report.

When i query permission table, it will only return Object ID and not Object name.

I had then manage to find the Object name in the table "Application Object Metadata" as follow.

However for Object ID 200XXXX onwards, the data is not stored in this table. Anyone know where is the object 200XXXX being stored? so that i can point and pull the object name?

However 6254.table.png

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Gearoid Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Maybe you can use the "Object Metadata Snapshot" table:

SELECT [Object ID]
,[Name]
FROM [Demo Database BC (18-0)_CU6_W1].[dbo].[Object Metadata Snapshot]
where [Object ID]='2000000111'

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,821 Super User 2026 Season 1

#2

YUN ZHU 1,122 Super User 2026 Season 1

#3

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans