0 votes

I have filled CustomAttributeText1 with a comma delimited list of numbers for a user. These numbers are unique identifiers for locations stored in out MS SQL database table.
I want to be able to get this list when I select the user from a drop down and use it to query a MS SQL database table to match it with the location names. I then want to display these location names on the web portal so that web portal users can see the locations that the user is tied to.
Is there a way for me to do this kind of customization to the web portal? Can you direct me towards tutorials for this sort of thing?

Thanks!

Edit: Another thought on how to handle this:

Is there a common place in AD where we could store a delimited list of key/value pairs? We are thinking that we might just store all of the location ID’s and location names in AD in one place and a list of location ID’s on the user object in the CustomAttributeText1 field. We could display a picklist with all of the locations and mark the locations that the user is tied to. If a new location is selected or an old location is deselected we could add or remove the location ID’s from the user’s list.
The main list of locations in AD would be kept up to date by a scheduled script and the locations tied to each specific manager would be pulled into our SQL database tables by a different scheduled script.

by (120 points)

1 Answer

0 votes
by (270k points)
selected by
Best answer

Hello Mark,

There is no common place in Active Directory where you might store the list of locations and their IDs. As a solution, you can use Property Patterns and one of Adaxes custom multi-value attributes (e.g. CustomAttributeTextMultiValue1). The list of allowed values for the attribute will be formed by a PowerShell script that will be querying your MS SQL database on a schedule basis. The values in the attribute will have the following format: locationName (locationID). This will allow you to have only one attribute storing both location names and identifiers instead of two. However, the drop-down list of locations will always be the same. There is no possibility to mark or exclude locations that are already selected for the user. When the attribute will get updated for a user, a Business Rule will query your MS SQL database and make required changes (assign/unassign the user to locations).
If this solution meets your needs, we will provide you with detailed instructions.

0

Since we would not be able to use the web portal to make changes to the list of locations for a user this approach won't work. We are now looking at using security groups as locations and add users to those groups.

Related questions

0 votes
1 answer

Hi We're experiencing some issues with showing and hiding custom commands when viewing user accounts. We have a number of commands in Adaxes, but no matter the permissions ... other custom commands shown. We're running the latest verison of 2021.1 Thanks Matt

asked Apr 5, 2022 by chappers77 (2.0k points)
0 votes
1 answer

We will be migrating from the default logging in the SQL Express database to a fully licenses MS SQL Server database. We would like for the existing logs to be ported over as well.

asked Dec 28, 2022 by bsteele (90 points)
0 votes
1 answer

Can the logging database be run on SQL 2019?

asked Jul 20, 2020 by rurbaniak (1.4k points)
0 votes
1 answer

Hello, Would it be possible to access the content of the basket through the SDK? My goal would be to use the basket to add many groups to a specific user (with a custom action). Thank you

asked Jul 1, 2013 by Pierre (750 points)
0 votes
1 answer

We have several Office 365 groups where the someone is an Owner but not a Member, and we'd like to give them the ability through the web interface to give them the ability ... option in the web interface to allow them to add or remove users via a custom task?

asked Nov 1, 2023 by PaulO (20 points)
3,326 questions
3,026 answers
7,727 comments
544,683 users