MitIDErhverv: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
Line 20: Line 20:
===SQL Sentence===
===SQL Sentence===
Insert parameters for filtering purposes
Insert parameters for filtering purposes
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 And MitIDErhverv_Users.MitIDErhvervSettings_ID = {(int)SettingsRow["ID"]}))
Order By SLI_ID


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

Revision as of 07:51, 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

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 And MitIDErhverv_Users.MitIDErhvervSettings_ID = {(int)SettingsRow["ID"]}))
Order By SLI_ID

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.