question

Hello

Thank you for your question and reaching out.

I can understand you wish to create views in SCSM.

You could create the view in the console, using a type projection for Work Item containing the affected user relationship.
However, if your end goal is to have it in the portal, you could create the same result much easier with a SQL Chart widget and a SQL query that brings in items from WorkItem table and Join with the CI$User table to link up location.

--If the reply is helpful, please Upvote and Accept as answer--

Hi @JonhAndersonBaquero-8596,

below you will find two articles with nice examples regarding SCSM Views:

Create View for Incidents that have not been modified in last 7 days
https://techcommunity.microsoft.com/t5/system-center-blog/create-view-for-incidents-that-have-not-been-modified-in-last-7/ba-p/341452

and also

SCSM Console Views
https://www.xapity.com/single-post/2017/05/17/console-views

Those will give you an idea how SCSM Views can be created!

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Stoyan Chalakov