Navigation

    Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    1. Home
    2. FlatErik
    F
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 11
    • Best 0
    • Groups 0

    FlatErik

    @FlatErik

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

    FlatErik Follow

    Latest posts made by FlatErik

    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @martinv ja! das ist die Hauptsache 🙂 Danke trotzdem!

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @MartinV der Download als CSV funktioniert und ist fehlerfrei- die Anzeige im Browser aber nicht. Habe es auch schon mit verschiedenen Browsern versucht.

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      Die nicht von uns geänderte Abfrage funktioniert:

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
      j2.isys_cats_lic_list__isys_obj__id AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
      
       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 
      LEFT JOIN isys_catg_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS j4 ON j4.isys_obj__id = j2.isys_cats_lic_list__isys_obj__id 
      LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
      
      WHERE TRUE 
       AND  ( (job9.isys_obj__id = '4272901' ) )
       ORDER BY j7.isys_cats_person_list__last_name ASC
      
      

      Die bearbeitete nicht:

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
      j4.isys_obj__title AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
      
       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 
      LEFT JOIN isys_catg_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS j4 ON j4.isys_obj__id = j2.isys_cats_lic_list__isys_obj__id 
      LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
      
      WHERE TRUE 
       AND  ( (job9.isys_obj__id = '4272901' ) )
       ORDER BY j7.isys_cats_person_list__last_name ASC
      
      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @flaterik Hallo Martin!

      Sehr seltsam: die Abfrage funktioniert seit heute auf einmal nicht mehr.
      Im "Report-Vorschau" klappt es, aber im normalen Report zeigt er nichts an.
      Auch haben sich die "Treffer" im Report von ca. 150 auf 100011 vervielfacht.

      Woran könnte das liegen?

      13.png

      12.png

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @martinv
      Hat auf anhieb leider nicht geklappt. Ich werde es weiter versuchen. Vielen Dank erstmal!

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @martinv Ist es im idoit möglich, die Abfrage auch dahingehend zu ändern, dass man sich die Anzahl der unterschiedlichen Lizenzen anzeigen lassen kann? Ich hab es mit group by probiert aber leier klappt es nicht..

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @martinv Super Danke es hat geklappt!

      posted in Betrieb
      F
      FlatErik
    • RE: Report: Anzeigen des Objektnamens anstatt Objekt-ID

      @martinv
      Danke! Leider wird mir weiterhin nur die Objekt-ID angezeigt.

      Folgende Abfrage habe ich jetzt:

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
      j2.isys_cats_lic_list__isys_obj__id AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
      
       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 
      LEFT JOIN isys_catg_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS j4 ON j4.isys_obj__title = j2.isys_cats_lic_list__isys_obj__id 
      LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
      
      WHERE TRUE 
       AND  ( (job9.isys_obj__id = '4272901' ) )
       ORDER BY j7.isys_cats_person_list__last_name ASC
      

      Hättest du noch eine Idee?

      Vielen Dank!

      posted in Betrieb
      F
      FlatErik
    • Report: Anzeigen des Objektnamens anstatt Objekt-ID

      Hallo!

      ich möchte in meinem Report anstelle der Objekt-ID (j2.isys_cats_lic_list__isys_obj__id) den Name/Title des Objektes 'Licence' anzeigen lassen. Könnte mir jemand bitte dabei helfen?

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
      j2.isys_cats_lic_list__isys_obj__id AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
      
       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 
      LEFT JOIN isys_catg_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS j4 ON j4.isys_obj__id = j2.isys_cats_lic_list__isys_obj__id 
      LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
      
      WHERE TRUE 
       AND  ( (job9.isys_obj__id = '4272901' ) )
       ORDER BY j7.isys_cats_person_list__last_name ASC
      
      posted in Betrieb
      F
      FlatErik
    • RE: Grundsätzliches zur Nutzung der i-doit API

      Ich denke eher nicht. Meiner Meinung deutet die Fehlermeldung eher darauf hin, dass an der syntax was falsch ist.. ('not a valid json rpc') Vielleicht werden die Gänsefüßchen oder klammern falsch aufgelöst? ich sende den curl befehl über die cmd.exe. Hat noch jemand eine Idee? VG!

      posted in Betrieb
      F
      FlatErik