Get unread channel messages for each user

Hi all.

I need to retrieve the list of unread channel messages for each user in order to create a graph for internal use in my company. Looks like there is no “impersonate” feature available via the API. Gitlab says this discussion will be moved to the forum, and the forum redirects to Gitlab. Dead end.

Is this somehow possible?
Or do I need to manually access the database for getting this info?