OTRS ITSM CMDB Inventory list

[covalle]

Dear Friends

I need to have a report for each Hardware I have on the system how I can get a report or statistics where it show me all the inventory?

Carlos Ovalle

[yuri0001]

Hi!
You can do it through CMDB search menu item & send output in CSV. But you must do it for each Class of Hardware.

[covalle]

Thanks Yuri

But this only show me the same info I see on CMDB overview

Class Incident State Name Number Deployment State Version Created
Hardware Operational SR2-AHU-A/C#3 1023000008 Production 17 03/08/2014 13:48:55
Hardware Operational SR2-AHU-A/C#4 1023000007 Production 16 03/08/2014 13:43:48
Hardware Operational SR2-A/C#2 1023000006 Production 14 03/08/2014 10:51:51


What I need is all the fields like serial, model, type, installed, etc. Is any way?

Carlos Ovalle

[yuri0001]

Hi Carlos!
There 2 points:
1. I tell you about output from search in CSV format. I have no my system in this moment. As I remember, list of fields is configured in SysConfig -> ITSMConfiguration Management --> ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData
2. There is no OTRS version in your profile. In v.3.3.x you may customize overview for each class separatly. It's also may be done via SysConfig -> ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###ShowColumns or ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###ShowColumnsByClass

[covalle]

Even i select ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###ShowColumnsByClass the info on the reports are the same

[yuri0001]

You must not only select this parameter, but enter there your configitem attributes as shown there as example. And see my point 1 for CSV output fields. Read comments for parameters carefully. Sorry my bad English

[covalle]

Thanks a lot Yuri it worked

Carlos Ovalle

[crashingOtrs]

Hi,
I followed all that Yuri suggested, but i cannot see the data of the columns i added.
I can get the CSV file with all the columns i want, but no data just the data on the default columns (Class, Incident State, Name, ConfigItem# Change State, Version, Create Time)
any suggestion?

Cheers,

[dtosun]

Export it from Admin page.

[bigarzabal]

Hi all, I'm still dealing with this issue. Along this thread it seams to be solved but I guess it isn't.
How can we add custom config item fields to the search CSV output?

from ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData seams not tu be possible.

Regards!!!

[ronaldjerardmedina]

Just like dtosun said, export it from the Admin Page. That's the most convenient way.