I have installed and configured Data collector for OCS Inventory NG and Data model for OCS Inventory, both in version 2.0, I use iTop 3.0.2 but I get the following error:
[2024-02-28 17:53:48][Error][OCSPCCollector] Failed to execute the query: '
SELECT b.SSN as primary_key,
h.ID as ocs_id,
h.NAME as name,
h.OSNAME as osfamily_id,
h.OSVERSION as osversion_id,
h.PROCESSORT as cpu,
h.MEMORY as ram,
b.SMANUFACTURER as brand_id,
b.SMODEL as model_id,
b.SSN as serialnumber,
h.WINPRODID as oslicence_id,
h.OSCOMMENTS as ocs_oscomment,
IF(h.IPADDR REGEXP '^[0-9a-f.:]{2,39}$',h.IPADDR,null) as ipaddress_id,
(select max(convert(cvss,DECIMAL)) from cve_search_computer sc where sc.hardware_id=b.hardware_id) as cvss,
'production' as status,
'Demo' as org_id
FROM hardware AS h
JOIN bios AS b ON h.id=b.hardware_id
JOIN (select ssn, max(hardware_id) id_max from bios group by ssn) last_bios on last_bios.id_max=h.id
WHERE b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')
AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
AND b.SSN!=''
'. Reason: 42S02, Table 'ocsweb.cve_search_computer' doesn't exist [2024-02-28 17:53:48][Error] OCSPCCollector::Prepare() returned false
Has this happened to anyone else, do you have a solution?
I was looking at the ocs inventory database and the cve_search_computer table does not exist, I thought it was because of the version of OCS inventory that I was using but in no version until 2.12 does this table exist, am I doing something wrong?
Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It is necessary to install the small extension Data model for OCS Inventory which adds some fields and an “OCS Inventory” link on synchronized PCs, Servers, Virtual Machines, Mobile Phones and software. This link opens a new tab with the OCS page of the device.
You should install this extension on you target iTop instance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello good morning
I have installed and configured Data collector for OCS Inventory NG and Data model for OCS Inventory, both in version 2.0, I use iTop 3.0.2 but I get the following error:
[2024-02-28 17:53:48] [Error] [OCSPCCollector] Failed to execute the query: '
SELECT b.SSN as primary_key,
h.ID as ocs_id,
h.NAME as name,
h.OSNAME as osfamily_id,
h.OSVERSION as osversion_id,
h.PROCESSORT as cpu,
h.MEMORY as ram,
b.SMANUFACTURER as brand_id,
b.SMODEL as model_id,
b.SSN as serialnumber,
h.WINPRODID as oslicence_id,
h.OSCOMMENTS as ocs_oscomment,
IF(h.IPADDR REGEXP '^[0-9a-f.:]{2,39}$',h.IPADDR,null) as ipaddress_id,
(select max(convert(cvss,DECIMAL)) from cve_search_computer sc where sc.hardware_id=b.hardware_id) as cvss,
'production' as status,
'Demo' as org_id
FROM hardware AS h
JOIN bios AS b ON h.id=b.hardware_id
JOIN (select ssn, max(hardware_id) id_max from bios group by ssn) last_bios on last_bios.id_max=h.id
WHERE b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')
AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
AND b.SSN!=''
'. Reason: 42S02, Table 'ocsweb.cve_search_computer' doesn't exist
[2024-02-28 17:53:48] [Error] OCSPCCollector::Prepare() returned false
Has this happened to anyone else, do you have a solution?
I was looking at the ocs inventory database and the cve_search_computer table does not exist, I thought it was because of the version of OCS inventory that I was using but in no version until 2.12 does this table exist, am I doing something wrong?
Thank you.
Hello,
See in the documentation :
You should install this extension on you target iTop instance.