# User Attributes First Name and Last Name mapped from database provider

**URL:** <https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439>\
**Category:** Ignition Early Access\
**Created:** [January 20, 2020, 8:24pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439 "2020-01-20T20:24:20Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [January 20, 2020, 8:24pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/1 "2020-01-20T20:24:20Z")

</div>

Is it possible to map the firstname and lastname attributes from a database provider to the internal identity provider? The attributes are present in the database provider but do not appear in the identity provider (see attached screenshots).  
Am i missing a setting or is it simply not possible?  
Ignition version is 8.0.7

 ![LoginTest](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8e25cdbda1ca5f601d46e6ed8064b00f7c670dea.jpeg) ![ProviderTest](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8fdc040e1a80fe62bd4d9304b6043a9c35ebd5cf.jpeg)

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [January 24, 2020, 1:42am UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/2 "2020-01-24T01:42:54Z")

</div>

You should be able to request them as long as you have the scope piece defined correctly in your Ignition IdP setup. See this following [entry from the Ignition Manual](https://docs.inductiveautomation.com/display/DOC80/OpenID+Connect+1.0+Example#OpenIDConnect1.0Example-ScopeData) about this. Step 11 of the configuration part gives some information about configuration in Ignition as well in the above article.

Garth

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [January 24, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/3 "2020-01-24T21:02:00Z")

</div>

Garth, thank you for this answer. But i don’t see the scope setting in 8.0.7. Is this a new setting in a nightly build?

 ![ProviderConfig](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0c229978361754716c4197bb473ec87f76e589c0.png)

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [January 27, 2020, 4:40pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/4 "2020-01-27T16:40:36Z")

</div>

@chi,

I apologize for the confusion. In looking at the original configuration I thought you were working with an OpenID connection and had missed setting up the request from the provider. For mapping attributes to items sent by the provider, there is an option under the `More` link for `User Attribute Mapping` that should allow you to map this attribute.

Manual Info:  
[https://docs.inductiveautomation.com/display/DOC80/User+Attribute+Mapping](https://docs.inductiveautomation.com/display/DOC80/User+Attribute+Mapping)

Garth

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [January 27, 2020, 8:10pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/5 "2020-01-27T20:10:10Z")

</div>

@ggross,

what is the correct path setting for the firstname, lastname and email attributes? I tried paths like ‘lastname’, ‘lname’, ‘Lastname’ and a lot of variations without success.  
I found that i can map every attribute that is displayed in the _IdP Response Data_ tab, e.g. _aud_. But as you can see in the screenshot in my original post, firstname an lastname do not appear in the response data.  
I’m sure i am missing a step here, but i have not idea what that can be.

---

<div class="post-metadata">

**Author:** ![jspecht](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jspecht/32/6465_2.png) [@jspecht](https://forum.inductiveautomation.com/u/jspecht)\
**Post date:** [January 27, 2020, 8:34pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/6 "2020-01-27T20:34:51Z")

</div>

The attributes in the below screen shot should work for you:

 ![40%20PM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a021973e88a63e4543e386d3f4d31e295e153fd8.png)

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [January 27, 2020, 8:43pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/7 "2020-01-27T20:43:54Z")

</div>

@jspecht I already tried this paths, but just checked again to make sure. No success  
I’m using the _Test Login_ function on the IdP configuration page and logged out again before changing the mappings.

Is there any special setting required in the Database user source?

---

<div class="post-metadata">

**Author:** ![jspecht](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jspecht/32/6465_2.png) [@jspecht](https://forum.inductiveautomation.com/u/jspecht)\
**Post date:** [January 27, 2020, 8:51pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/8 "2020-01-27T20:51:35Z")

</div>

If you are using a Database User Source, [you need to make sure the firstname / lastname columns are set in your Authentication Query and List Users Query](https://docs.inductiveautomation.com/display/DOC80/Database+Authentication#DatabaseAuthentication-ManualMode).

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [January 27, 2020, 8:57pm UTC](https://forum.inductiveautomation.com/t/user-attributes-first-name-and-last-name-mapped-from-database-provider/31439/9 "2020-01-27T20:57:43Z")

</div>

Thank you!

Firstname and lastname where missing in the List Users Query. Now it works as expected.
