Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login
    1. Home
    2. beckmann
    B
    Offline
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 3
    • Groups 0

    beckmann

    @beckmann

    0
    Reputation
    4
    Profile views
    3
    Posts
    0
    Followers
    0
    Following
    Joined
    Last Online

    beckmann Unfollow Follow

    Latest posts made by beckmann

    • RE: SSO - Single Sign On

      @Andy-Schlünz
      Hey Andy,
      das scheint zwar ein älteres Thema zu sein, aber dieses Vorgehen haben wir schon häufiger erfolgreich umgesetzt. Dabei hilft diese Anleitung:
      https://kb.i-doit.com/display/de/i-doit+mit+OpenID-Connect+Authentifizierung+am+Beispiel+Google+Login

      Ein hilfreicher Tipp ist, den Zugang nur über die Domain per SSO zu realisieren, und z.B. über die IP das SSO nicht in der Apache Config zu hinterlegen. So kann man sich noch mit dem lokalen Admin-Konto (oder anderen Benutzern, die nur in der Datenbank sind) anmelden. Ein Single-Sign-Out funktioniert nämlich nicht.

      Viele Grüße
      Jan

      posted in Betrieb
      B
      beckmann
    • RE: Report-Manager Erweiterung des Reports um Lokation - Verfügbare Kapazitäten aller Schränke

      Ich habe es mal zusammengeklickt:

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      obj_main.isys_obj__title AS 'Schrank',
      obj_main.isys_obj__sysid AS 'SYS-ID',
      SUM(
          IF(
              !ISNULL(
                  isys_catg_location_list__pos
              )
              AND isys_catg_location_list__pos != 0, 1, 0
          )
      ) AS 'Anzahl Elemente',
      
      CONCAT(
          IF(
              !ISNULL(rack.isys_catg_formfactor_list__rackunits),
              rack.isys_catg_formfactor_list__rackunits - SUM(
                  IF(
                      ISNULL(
                          isys_catg_location_list__pos
                      )
                      OR isys_catg_location_list__pos = 0
                      , 0, dev.isys_catg_formfactor_list__rackunits
                  )
              ),
              rack.isys_catg_formfactor_list__rackunits
          )
          , ' HE'
      ) AS 'Verbleibende Kapazitaet',
      j2.isys_catg_location_list__parentid AS 'isys_cmdb_dao_category_g_location::dynamic_property_callback_location_path::isys_catg_location_list__parentid::LC__CMDB__CATG__LOCATION_PATH' 
      
       FROM isys_obj AS obj_main
      INNER JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id
      INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id
      INNER JOIN isys_catg_formfactor_list rack ON rack.isys_catg_formfactor_list__isys_obj__id = isys_obj__id
      LEFT JOIN isys_catg_location_list AS j2 ON obj_main.isys_obj__id = j2.isys_catg_location_list__isys_obj__id 
      LEFT JOIN isys_obj AS j3 ON j3.isys_obj__id = j2.isys_catg_location_list__isys_obj__id 
      LEFT JOIN isys_obj_type AS j4 ON j4.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id
      LEFT JOIN isys_catg_formfactor_list dev ON dev.isys_catg_formfactor_list__isys_obj__id = isys_catg_location_list__isys_obj__id
      
      
      WHERE TRUE 
       AND  ( (j4.isys_obj_type__id != '60' ) AND (j4.isys_obj_type__id != '63' ) )
       ORDER BY obj_main.isys_obj__title DESC
      
      posted in Entwicklung
      B
      beckmann