Wiki von Harald Schmid - ksh:queries
https://wiki.hschmid-it.de/
2026-05-08T03:31:45+00:00Wiki von Harald Schmid
https://wiki.hschmid-it.de/
https://wiki.hschmid-it.de/lib/exe/fetch.php?media=wiki:logo.pngtext/html2025-04-08T12:47:40+00:00Anonymous (anonymous@undisclosed.example.com)ssystemsview
https://wiki.hschmid-it.de/doku.php?id=ksh:queries:ssystemsview&rev=1744116460&do=diff
SSystemsView
in der kdb - Abfrage für SSystems / Shibboleth
SELECT DISTINCT
p.id AS id,
p.apid AS apid,
p.login AS login,
p.login_old AS login_old,
p.lastname AS lastname,
p.firstname AS firstname,
p.birthname AS birthname,
p.birthdate AS birthdate,
c.pass AS pass,
c.pass_freeradius AS pw_sha512,
c.unsec AS unsec,
(CASE g.caption
WHEN 'lecturers' THEN
p.email_ksh
# geändert am 08.04.2025
# IF((RIGHT(p.mail, 9) = '@ksh-m.de'), p.mail, IF(ISNULL(va2.source), p.mail, va2.sou…