Personally, I use OCS inventory to check equipment via SNMP.

Not sure i-doit is able to support SNMP natively...

Hi,

No problem on my side. i-doit imports data from OCS DB, including software information.

Matt

Thank you for your feedback !

Hi all,

I'm wondering how it is possible to search equipment which host specific version of software (example: search and display equipment powered by CentOS 7.0).

Is it possible ?

Thank you

Thanks for your feedback.

I made a new test with interesting result:

• filesytem resize on virtual client (OCS agent)

• new size information is present in OCS server

• import process execution in i-doit but information has not been upgraded in i-doit

• deletion of FS in i-doit drive category

• new import from OCS

• filesystem reappeared in i-doit with new size

So it concerns only information update…

Hi Quyen,

Thanks for your interest in my post.
Basically, I'm tryin to update/import all categories of this virtual client.

Below, message printed in the web interface during import:

No possible FQDN found for "yutu".
Using object match profile "Default" for object matching.
Found Object "yutu" with ID "23".
Updating existing object yutu (Virtual client)
Processing model
Processing CPUs
Processing memory
Processing Operating system
Processing applications
Processing graphics adapter
Processing sound adapter
Processing drives
Processing network
Processing UI
Processing storage
yutu succesfully updated

Import successful

And below, content of log found in [i-doit Root folder]/log folder:

i-doit 1.9.1 PRO

host URL 127.0.0.1

log for "import_ocs"

started at 2017-07-11T17:13:08+02:00

written to "/var/www/html/i-doit/log/import_ocs_2017-07-11_17_13_08.log"

[2017-07-11 17:13:09 0.09031300] INFO: Following categories are selected for the import: Operating System, CPU, Memory, Software assignment, Network, Devices, Graphic card, Sound card, Model, Interface, Drives,
[2017-07-11 17:13:09 0.09032600] INFO: Preparing environment data for the import.
[2017-07-11 17:13:09 0.14279200] INFO: Starting Import.
[2017-07-11 17:13:09 0.14280400] INFO: Device count: 1
[2017-07-11 17:13:09 0.36817900] INFO: Processing device: "yutu".
[2017-07-11 17:13:09 0.36823400] DEBUG: MAC-addresses found for yutu.
[2017-07-11 17:13:09 0.36823700] DEBUG: Serial found for "yutu".
[2017-07-11 17:13:09 0.36824400] DEBUG: No possible FQDN found for "yutu".
[2017-07-11 17:13:09 0.36824500] DEBUG: Checking object type.
[2017-07-11 17:13:09 0.36825700] DEBUG: Object type is set in the dialog. Using selected Object type Virtual client for "yutu".
[2017-07-11 17:13:09 0.40865000] INFO: Using object match profile "Default" for object matching.
[2017-07-11 17:13:09 0.42866700] INFO: Found Object "yutu" with ID "23" via object matching.
[2017-07-11 17:13:09 0.42868100] INFO: Object found. Updating object-ID: 23
[2017-07-11 17:13:09 0.43026800] DEBUG: Updating object with object type: LC__CMDB__OBJTYPE__VIRTUAL_CLIENT.
[2017-07-11 17:13:09 0.48996400] INFO: Processing model
[2017-07-11 17:13:09 0.54725000] INFO: Processing CPUs
[2017-07-11 17:13:09 0.55945700] INFO: Processing memory
[2017-07-11 17:13:09 0.59407600] INFO: Processing Operating system
[2017-07-11 17:13:09 0.71113100] INFO: Processing applications
[2017-07-11 17:13:10 0.32736100] INFO: Processing graphics adapter
[2017-07-11 17:13:10 0.34071700] INFO: Processing sound adapter
[2017-07-11 17:13:10 0.39116400] INFO: Processing drives
[2017-07-11 17:13:10 0.46943200] INFO: Processing network
[2017-07-11 17:13:10 0.48457700] INFO: Processing UI
[2017-07-11 17:13:10 0.49064200] INFO: Processing storage
[2017-07-11 17:13:10 0.49922900] INFO: "yutu" succesfully updated.
[2017-07-11 17:13:10 0.49955600] INFO: Import successful

For instance, this server has now 2 cores (CPU) after upgrade but still 1 core is show in i-doit (2 in OCS).

Thank you.

Hi all,

We are currently testing i-doit to define it replies to our needs or not.

We're facing an issue when we import data from OCS.

First import is okay and CI is created in i-doit DB but when CI is modified (information is updated in OCS DB) and import is executed in i-doit, CI is not updated in i-doit.
There is not specific error except this one:

[2017-07-03 17:21:29 0.35336100] ERROR: Exception Trace:

• File: /var/www/html/i-doit/controller.php (line: 507)
  isys_handler_ocs->init
• File: /var/www/html/i-doit/src/handler/isys_handler_ocs.class.php (line: 173)
  isys_handler_ocs->process
• File: /var/www/html/i-doit/src/handler/isys_handler_ocs.class.php (line: 5692)
  isys_component_signalcollection->emit
• File: /var/www/html/i-doit/src/classes/components/isys_component_signalcollection.class.php (line: 286)
  idoit\Module\Cmdb\Search\IndexExtension\Signals->onPostImport
• File: /var/www/html/i-doit/src/classes/modules/cmdb/src/Search/IndexExtension/Signals.php (line: 132)
  idoit\Module\Cmdb\Search\IndexExtension\OnelineIndexer->index
• File: /var/www/html/i-doit/src/classes/modules/cmdb/src/Search/IndexExtension/OnelineIndexer.php (line: 485)
  isys_component_database_mysqli->query
• File: /var/www/html/i-doit/src/classes/components/isys_component_database_mysqli.class.php (line: 593)
  Message: "Database error : Query error: 'REPLACE INTO isys_search_idx (isys_search_idx__version, isys_search_idx__type, isys_search_idx__key, isys_search_idx__value, isys_search_idx__reference) SELECT 1, 'cmdb', CONCAT(isys_obj__isys_obj_type__id, '.global.', isys_catg_global_list.isys_catg_global_list__id, '.tag'), isys_tag__title, isys_catg_global_list__isys_obj__id FROM isys_catg_global_list INNER JOIN isys_tag_2_isys_obj ON (isys_catg_global_list__isys_obj__id = isys_tag_2_isys_obj.isys_obj__id OR isys_catg_global_list.isys_catg_global_list__id = isys_tag_2_isys_obj.isys_obj__id) INNER JOIN isys_tag ON isys_tag.isys_tag__id = isys_tag_2_isys_obj.isys_tag__id INNER JOIN isys_obj ON isys_catg_global_list__isys_obj__id = isys_obj.isys_obj__id WHERE !ISNULL(isys_tag_2_isys_obj.isys_obj__id) AND isys_obj__id IN(23) AND isys_obj__isys_obj_type__id NOT IN(34,37,63,60,30,72,80,79,40);':
  Column 'isys_obj__id' in where clause is ambiguous

Any idea if we missed a setting or something else ?

Thank you in advance.

• OCS version: 2.3

• i-doit version: 1.9.1 PRO

BR,
Matt