Hi All,
I want to know where exactly the CMDB data is store as I check the database their all the data is not getting store.
for eg.
i want to know where the below value pick by OTRS
Name: Laptop
Deployment State: Maintenance
Incident State: Operational
Vendor: Dell
Model: Dell
Description: OS -10
Type: Laptop
Owner: customer name
Serial Number: 111111111111111
Operating System: 10
CPU:
CPU:
Ram:
Hard Disk:
regards,
Mohsin khan
OTRS CMDB Storage
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: OTRS CMDB Storage
Hello Mohsin,
they are stored in `xml_storage` and in `configitem*`.
Query:
This database structure makes developing unnecessarily complex.
Best regards
Emin
they are stored in `xml_storage` and in `configitem*`.
Query:
SELECT *
FROM `xml_storage`
WHERE xml_type LIKE 'ITSM::ConfigItem::%';
This database structure makes developing unnecessarily complex.
Best regards
Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: OTRS CMDB Storage
Thanks Emin,
For your Quick reply...
regards,
Mohsin khan
For your Quick reply...
regards,
Mohsin khan