· On-premise Active Directory
· Exchange Online
· SharePoint Online
The given request during a project was to generate an overview list containing all user information in the environment.The collaboration portal is running on Office 365. All given user information such as, department, manager, location etc. are based on an import via PowerShell into the Office 365 System.
Because of the synchronization between Exchange Online, and the associated SharePoint Online System the SharePoint User Profile Service also gets that information. In addition users are able to fill in personalized information like phone number, mobile number, office room number etc. They can do this via SharePoint MySite or they can use Outlook to complete their profiles.
So as a result, we get mostly completed and actual user profiles.
Using that URL call, you get a list of all users in your SharePoint System:_layouts/people.aspx?MembershipGroupId=0
Based on this we now can create and refine the information and build an employees information Site in SharePoint Online:
In the following basic SharePoint function we can modify the view or bring in some new columns:
First of all I recommend to create a new view and let the system default views as they are.
I created a view called DEMO. You can see that this view will be placed under a different URL:_catalogs/users/detail.aspx
This is a character of this special system view…
Now I do some additional configuration.At first I only want to see real users using that filter:
It works, because objects like “NT AUTHORITY\authenticated users” do not have a forename.In the next step I add a calculated column which I will use for group and filter functionality:
As a result my list will look like this:
Here are some examples what you can do now based on that:Using the calculated column “_name” you can realize a filter by initial:
Or another example is a filter based on subsidiary map
As you can see all that also works on the new SharePoint 2013 version.