search colums on config items

Moderator: crythias

Post Reply
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

search colums on config items

Post by dcorbera »

Hello.

When we search a group of config items on the CMBD, how can we add colums on the resultat. We have added a new field named "Center" on the configitem definition, and we need it on the search result report.

Many thanks.
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: search colums on config items

Post by dcorbera »

Any response. This a important point for us.
Thanks.
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: search colums on config items

Post by dcorbera »

Any response?
Many thanks...
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: search colums on config items

Post by yuri0001 »

Hi!
To my mind in current version it only may be configured for result in CSV format.
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: search colums on config items

Post by dcorbera »

It doesn't work for me. How can activate it?
Thanks
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: search colums on config items

Post by yuri0001 »

SysConfig in ITSM Configuration Management -> Frontend::Agent::ViewConfigItemSearch --> ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData
Add there your own fields you need. :?
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
wurzel
Znuny guru
Posts: 3232
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: search colums on config items

Post by wurzel »

Hi,
dcorbera wrote:Any response. This a important point for us.

look in sysconfig for the CI Culoms.


you can't demand for help in community forums. If it is important, buy professional services.

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: search colums on config items

Post by dcorbera »

We tried it, but only appears the field name on the header, and not the value, really I don't understand it...
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
DarealNeo
Znuny newbie
Posts: 16
Joined: 07 May 2014, 11:04
Znuny Version: 3.3.6
Company: JBW-AWO

Re: search colums on config items

Post by DarealNeo »

I have the same problem here.
Anybody here for solutions
crashingOtrs
Znuny newbie
Posts: 5
Joined: 19 Feb 2015, 14:15
Znuny Version: 3.3.9

Re: search colums on config items

Post by crashingOtrs »

Hi,
did someone find a solution for this ???
thanks in advance!!
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: search colums on config items

Post by RStraub »

Well, did you add them in:

ITSM Configuration Management -> Frontend::Agent::ViewConfigItemSearch

under:
ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###ShowColumnsByClass

Didn't this work for you ?
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

Hi,

i have the same problem.

I have added

ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###ShowColumnsByClass


under:
ITSM Configuration Management -> Frontend::Agent::ViewConfigItemSearch

and i have defined the fields i need.

So, when I search with normal output, i obtain the correct fields.
When I search with output sets to csv or print mode, i obtain only the default values: Class Incident State Name Number Deployment State Version Create Time!
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: search colums on config items

Post by RStraub »

Did you check the setting directly below ?

Code: Select all

ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

yes it is checked.
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: search colums on config items

Post by yuri0001 »

Hi, try to add the columns you need in this SysConfig item -
ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData
At first you must check this item and then add needed columns there.
But it's not fact that it true, because there no opportunity to specify class.
Another way is to use Import/Export for this.
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

This flag ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData is checked. S

o i have tried to add the column i need, but the only result is: A csv file with new header (my column) but with no data:

"Class";"Incident State";"Name”;”ConfigurationItem”;”ChangeState";"Version";"Create Time";"MyColumn"
"OSManager";"Incident";"GRFCTX005RM044";"0199000008";"Pilot";"31";"2015-04-13 15:39:29"
"OSManager";"Operational";"GRFCTX004RM044";"0199000007";"Test/QA";"29";"2015-04-13 15:38:42"
"OSManager";"Operational";"GRFAWB002RM257";"0199000006";"Production";"23";"2015-04-13 15:37:36"
"OSManager";"Operational";"GRFAWB001RM257";"0199000005";"Production";"24";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFSQL001RM257";"0199000004";"Production";"25";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX003RM044";"0199000003";"Production";"26";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX002RM044";"0199000002";"Production";"27";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX001RM044";"0199000001";"Production";"28";"2015-04-13 15:37:37"

While, if i substitute one of the default column "ConfigurationItem" (on csv section) with my column, i obtain this result:

"Class";"Incident State";"Name";"MyColumn";"ChangeState";"Version";"Create Time"
"OSManager";"Incident";"GRFCTX005RM044";"0199000008";"Pilot";"31";"2015-04-13 15:39:29"
"OSManager";"Operational";"GRFCTX004RM044";"0199000007";"Test/QA";"29";"2015-04-13 15:38:42"
"OSManager";"Operational";"GRFAWB002RM257";"0199000006";"Production";"23";"2015-04-13 15:37:36"
"OSManager";"Operational";"GRFAWB001RM257";"0199000005";"Production";"24";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFSQL001RM257";"0199000004";"Production";"25";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX003RM044";"0199000003";"Production";"26";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX002RM044";"0199000002";"Production";"27";"2015-04-13 15:37:37"
"OSManager";"Operational";"GRFCTX001RM044";"0199000001";"Production";"28";"2015-04-13 15:37:37"

the only change is only on the header, but the values ​​are still those of the field configuration items.

Maybe I 'm wrong something ?

Import/Export is a functionality only for admin, while I want to give a more controlled functionality to end users.
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

No ideas?
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: search colums on config items

Post by EXG133 »

We have several additional fields that work fine.

Did you fill it in like this:

'DynamicField_MyColumn'

In the SysConfig?


EDIT: Reading comprehension! That's a Dynfield for a change, not a ConfigItem.
yuri0001
Znuny superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: search colums on config items

Post by yuri0001 »

Hi!
Where is this attribute in SysConfig?
Thanks!
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

I don't understand. Which attribute?
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
schism
Znuny newbie
Posts: 11
Joined: 24 Jun 2013, 16:45
Znuny Version: 4.0.10

Re: search colums on config items

Post by schism »

Hi,

i have patched to new version of OTRS 4.0.7 -> 4.0.8 e ITSM Configuration Management 4.0.7 --> 4.0.8

But the problem with search on csv file is still here:

the only change is only on the header, but the values ​​are still those of the previosly field configuration items, or, if it is a new field the values are missing.

"Classe";"Stato dell'Incidente";"Name";"ConfigItem#";"ChangeState";"Tempo di Creazione"
"Class1";"Operational";"1";"01118000825";"Prepared";"13457";"2015-04-24 16:44:48"
"Class1";"Incident";"2";"01118000824";"Failed";"14177";"2015-04-24 17:37:11"
"Class1";"Incident";"3";"01118000823";"Failed";"14176";"2015-04-24 17:37:10"
"Class1";"Incident";"4";"01118000822";"Failed";"14173";"2015-04-24 17:37:05"
"Class1";"Incident";"5";"01118000821";"Failed";"14172";"2015-04-24 17:36:50"
"Class1";"Incident";"6";"01118000820";"Failed";"14171";"2015-04-24 17:36:39"
"Class1";"Incident";"7";"01118000819";"Failed";"14170";"2015-04-24 17:36:37"

"Classe";"Stato dell'Incidente";"Name";"My Column;"ChangeState";"Tempo di Creazione"
"Class1";"Operational";"1";"01118000825";"Prepared";"13457";"2015-04-24 16:44:48"
"Class1";"Incident";"2";"01118000824";"Failed";"14177";"2015-04-24 17:37:11"
"Class1";"Incident";"3";"01118000823";"Failed";"14176";"2015-04-24 17:37:10"
"Class1";"Incident";"4";"01118000822";"Failed";"14173";"2015-04-24 17:37:05"
"Class1";"Incident";"5";"01118000821";"Failed";"14172";"2015-04-24 17:36:50"
"Class1";"Incident";"6";"01118000820";"Failed";"14171";"2015-04-24 17:36:39"
"Class1";"Incident";"7";"01118000819";"Failed";"14170";"2015-04-24 17:36:37"

Maybe I 'm wrong something ?
Currently testing:
OTRS 4.0.7 + OTRS ITSM 4
RedHat 5.2 64bit
Apache 2.2.25
MySql 5.6.14
Post Reply