Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    I-doIT importiert Software die in OCS auf "ignorieren" gesetzt ist

    Scheduled Pinned Locked Moved Entwicklung
    2 Posts 2 Posters 829 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R Offline
      robert.sommer
      last edited by

      Hallo,

      beim importieren von Linux Maschinen unter der Verwendung von OCS habe ich festgestellt, dass Software-Objekte die auf dem OCS Inventory NG Server Web Frontend (/ocsreports) auf "ignoriert" gesetzt waren trotzdem importiert werden.

      Dies kann durch folgende Anpassung von /var/www/idoit/src/classes/components/isys_component_dao_ocs.class.php gelöst werden.
      Wenn Version 1.8.0 (Pro) ist das Problem immer noch vorhanden.

      
      public function getSoftware($p_hardwareID, $p_snmp = false) {
                  if ($p_snmp)
                  {
                              $l_query = "SELECT * FROM snmp_softwares WHERE SNMP_ID = " . $this->convert_sql_id($p_hardwareID);
                  }
                  else
                  {
                              $l_query = "SELECT * FROM hardware " . "INNER JOIN softwares ON softwares.HARDWARE_ID = hardware.ID AND softwares.NAME != '' AND softwares.NAME not in (select dico_ignored.EXTRACTED from dico_ignored) " . "WHERE hardware.ID = " . $this->convert_sql_id(
                                                      $p_hardwareID
                                          ) . " AND hardware.OSNAME != softwares.NAME";
                  } // if
      
                  return $this->retrieve($l_query); }
      
      /**
      * Get all applications only from hardware
      *
      * @return isys_component_dao_result
      */
      public function getAllSoftware()
      {
                  $l_query = "SELECT DISTINCT(softwares.NAME) FROM softwares " . "LEFT JOIN hardware ON hardware.OSNAME = softwares.NAME " . "WHERE hardware.OSNAME IS NULL AND softwares.NAME not in (select dico_ignored.EXTRACTED from dico_ignored)";
      
                  return $this->retrieve($l_query); }
      
      

      Wobei konkret folgender Einschub das Problem löst.

      
      AND softwares.NAME not in (select dico_ignored.EXTRACTED from dico_ignored)
      
      

      Kann dies eventuell in der folgenden Version berücksichtigt werden?

      Danke im Voraus.

      Gruß
      Robert

      1 Reply Last reply Reply Quote 0
      • dkirstenD Offline
        dkirsten administrators
        last edited by

        Hi,

        ist in Version 1.8.3 dann mit "drin". Danke für die Ergänzung!

        Viele Grüße,

        Daniel

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post