User Security Status - some user missing records in this page

(5) Share

Report

Posted on by Tom Schlund

We found that some of our users did not have a record in the User Security Status table. From what I have found from googling, this could be related to their Microsoft Entra ID, but I don't know what about it would cause them to fallout. I was able to put the missing users into the table with a config pack, but I'm worried that a future sync with "Update users from Microsoft 365" will re-break these users, or if future users may be impacted. Can someone help me understand the criteria for a record being created in this table?

Extra Info

We only discovered this issue because in an extension a third part built for us they used this table to look up a user name by the security id. For the users that were missing, it obviously didn't return the name.

Page: User Security Status List (9818, List)
Table: User Security Status (9062)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Are they all customized functions? I checked several environments and this page is empty.

Hopefully other experts can give you better advice.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

I agree with @YUN ZHU as I am also seeing empty page in 3 different 3 environment.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Tom Schlund 68 on at

Like (3)

Report
Copy link

Link copied!

Interesting, I had assumed it was some out of the box functionality they leveraged when they built this extension for us. We don't have a relationship with that company anymore, but we have the extension code. Maybe it would be wise to just update the function to do the lookup against the user table instead of this User Security Status.

local procedure GetUserName(UserID: Guid): Text var
User: Record "User Security Status"; //update this to User
begin
Clear(User);
if User.Get(UserID)then begin
User.CalcFields("User Name"); //remove
exit(User."User Name");
end
else
exit(UserID);
end;

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

The table you mentioned will not contain any data as this is used for security status checks and review only not for permanent database for user records.

You can use table User (2000000120) which can give you User name by using User Security ID as filter.

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Regards,

Dhiren.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: User Security Id (SID) and User Id (Name)

https://yzhums.com/25881/

How to display User Name from SystemCreatedBy/SystemModifiedBy field on the page (Translate a user security ID GUID to the corresponding user name)

https://yzhums.com/46070/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

The User Security Status table is populated automatically when users are synchronized from Microsoft 365 (Entra ID). If a user doesn’t appear there, it usually means their account wasn’t fully synced — often due to missing licenses, disabled accounts, or sync issues. Manually adding them via config pack is only a temporary fix; the correct approach is to run Update Users from Microsoft 365 in the Users page and make sure the users have the right Business Central license/permissions. If the problem continues, I recommend involving your Microsoft Partner to review the sync process and extension dependency.

✅ Mark this as the verified answer if helpful.

1 people found this reply helpful.

Was this reply helpful? Yes No