MitIDErhverv: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
Line 39: Line 39:
  And (WorkMail <> '')''
  And (WorkMail <> '')''
  And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
  And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
<Your SQL Sentence>


=== Parameters ===
=== Parameters ===

Revision as of 07:52, 16 March 2023

UMS Configurator settings

Description

Insert a name or description for the setting

Admin servers

Choose the admin server created here MitID Erhverv

Maintain groups

This will created/update and delete groups.

It will also add users and remove them again.

These groups can be used to add security to users based on group membership.

Authenticators

Choose the authenticators to add to users.

SQL Sentence

Insert parameters for filtering purposes

You can test it by using this SQL command and appending your own SQL sentence.

Select Distinct Students.SLI_ID, Students.Fornavne As GivenName, Students.Efternavn As SurName, Students.CPR As CivilRegistrationNumber
, Students.WorkMail
From Students
Where
(StudieNr Is Not Null)
And (UserTypes_ID = 0)
And (SLI_ID Is Not Null)
And (CPR Is Not Null)
And (BirthDay Is Not Null)
And (Fornavne Is Not Null)
And (Fornavne <> )
And (Efternavn Is Not Null)
And (Efternavn <> )
And (WorkMail Is Not Null)
And (WorkMail <> )
And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
<Your SQL Sentence>

Parameters

Users
Parameter Description
UsersOnly Runs all the parameters in this table
CreateUsers Create users
UpdateUsers Update users. This will also add authenticators if they are missing from the users.
DeleteUsers Delete users
Groups
Parameter Description
GroupsOnly Runs all the parameters in this table
CreateGroups Create groups
UpdateGroups Update groups
DeleteGroups Delete groups
AddGroupMembers Add new members to groups
RemoveGroupMembers Remove members from groups if they are no longer member of the group in the source data

FAQ

Find existing users

The user must be active for UMS to find the user otherwise it will create a new user.