How to edit multiple Configuration Item

[vaishali_dolas]

Hi,
I have following doubt please help me.
1. complete Configuration Item information is not stored in database.It is just saving part of information.
So where can i locate my Colmplete CI information?
Is there any way to view complete set of CI view in DB or in xml form?

2. Is there any way to take bulk action on existing CI??

any kind of help is appreciated.

[Wolfgangf]

2. Is there any way to take bulk action on existing CI??

you could use the Import/Export module for that

[Lorenzo_Marschall]

1. complete Configuration Item information is not stored in database.It is just saving part of information.
So where can i locate my Colmplete CI information?
Is there any way to view complete set of CI view in DB or in xml form?

I'm not sure, whether my answer fits your question, but the complete configuration item (ci) information is stored in the database (table xml_storage). But please make sure you understand the concept behind the implemention OTRS made concerning the configuration management database (cmdb):

You can define the "fields" of your cmdb within OTRS by your own. Have a look at Admin|Config Item and Admin|General Catalog. Therefore you won't find "one" complete dataset in "one" database row, but in several rows.
It's a matrix: number of fields (one field per row) + number of versions (one version & field per row).

Accessing data of the xml_storage table directly isn't the best way.

http://doc.otrs.org/itsm/2.0/en/html/ch06.html#id572244

HTH.

[vaishali_dolas]

Hi Lorenzo,
Thanks for reply.
Your information is definitely helpful for me yes i could see mapping of version & fileds.
But i want to perform bulk action on CI.If ill write some kind of trigger to directly manipulate database so that i can update multiple CI in single click.
Or if any other option is available to edit multiple existing CI in single shot please suggest me next possible workaround.


Hi Walfgangf,
Thanks for your reply.
Solution given by you to Imort/Export module is not going to help in my case.Because Importing new file will not editing existing CI but creating new CI's in database so that option is not going to work in my case..