View on User table with additional information Field

Hi All,

I need to create a custom metadata with a list of users from a specific department.

I have department name field in the User table ( created additional information field through User Admin).

But when I try to create a view from Configuration manager, the additional fields (Department) are not showing in the  columns after selecting the User table.

Is there anyway to retrieve this column values through the schema view?

Or Is it possible to make a restricted list in the custom metadata by idoc script(filter User View based on department field value)?

Thanks & Regards,

-Mukesh