CMDB Overview columns

Moderator: crythias

Post Reply
lmasal
Znuny newbie
Posts: 6
Joined: 10 Jul 2014, 09:21
Znuny Version: 3.3.8

CMDB Overview columns

Post by lmasal »

Hi people, does anyone know is it possible to change or add different columns in CMDB overview? I need columns with serial numbers of devices so it's easier to find device?

Thanks.
You do not have the required permissions to view the files attached to this post.
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub »

Yes, you can add them in the SysConfig:
ITSM Configuration Management -> ViewConfigItem and ViewConfigItemSearch.
There, edit the entry ending in "###ShowColumnsByClass" and add the fields you want to see for that class.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
lmasal
Znuny newbie
Posts: 6
Joined: 10 Jul 2014, 09:21
Znuny Version: 3.3.8

Re: CMDB Overview columns

Post by lmasal »

Hi, it worked.

Thanks for help. :)
Stevo
Znuny newbie
Posts: 16
Joined: 25 Nov 2013, 11:59
Znuny Version: 3.3.7

Re: CMDB Overview columns

Post by Stevo »

Having done this, is it possible to make the added columns sortable?
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub »

I'd be very interested in that as well. From a quick glance at the perl files, I'd guess you have to edit this:

Code: Select all

    # hash with all valid sortable columuns (taken from TicketSearch)
    # SortBy  => 'Age',   # Owner|Responsible|CustomerID|State|TicketNumber|Queue
    # |Priority|Type|Lock|Title|Service|SLA|Changed|PendingTime|EscalationTime
    # | EscalationUpdateTime|EscalationResponseTime|EscalationSolutionTime
    $Self->{ValidSortableColumns} = {
        'Age'                    => 1,
        'Owner'                  => 1,
        'Responsible'            => 1,
        'CustomerID'             => 1,
        'State'                  => 1,
        'TicketNumber'           => 1,
        'Queue'                  => 1,
        'Priority'               => 1,
        'Type'                   => 1,
        'Lock'                   => 1,
        'Title'                  => 1,
        'Service'                => 1,
        'Changed'                => 1,
        'SLA'                    => 1,
        'PendingTime'            => 1,
        'EscalationTime'         => 1,
        'EscalationUpdateTime'   => 1,
        'EscalationResponseTime' => 1,
        'EscalationSolutionTime' => 1,
    };
If you take then a look at the mentioned ticket search, it reads:

Code: Select all

SortBy  => 'Age',   # Owner|Responsible|CustomerID|State|TicketNumber|Queue|Priority|Age|Type|Lock
                           # Changed|Title|Service|SLA|PendingTime|EscalationTime
                           # EscalationUpdateTime|EscalationResponseTime|EscalationSolutionTime
                           # DynamicField_FieldNameX
                           # TicketFreeTime1-6|TicketFreeKey1-16|TicketFreeText1-16
                          
So it seems to be possible, but I cannot provide a working code.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
sampson
Znuny newbie
Posts: 2
Joined: 18 May 2015, 11:17
Znuny Version: 4.0.7
Real Name: Sampson Fung
Company: The Executive Centre

Re: CMDB Overview columns

Post by sampson »

RStraub wrote:Yes, you can add them in the SysConfig:
ITSM Configuration Management -> ViewConfigItem and ViewConfigItemSearch.
There, edit the entry ending in "###ShowColumnsByClass" and add the fields you want to see for that class.
I created a new Class "L" by copying the default "Location" class.

Then I can add new CDMB entries one by one.

I then add the following to the "ViewConfigItem"

L::Phone1, but this never show up in the overview.

If I include
L::Name
L::Number
They are shown without problems.

Anything I am missing?

I am testing with a OTRS 4.0.8 and matching ITSM in a new installation and an empty DB.

Regards,
Sampson
sampson
Znuny newbie
Posts: 2
Joined: 18 May 2015, 11:17
Znuny Version: 4.0.7
Real Name: Sampson Fung
Company: The Executive Centre

Re: CMDB Overview columns

Post by sampson »

I solved the problem by putting:

L::Phone::1

For any custom fields added to CMDB class, by including the "::1" to the "Key", the column will be included correctly.

Regards,
Sampson
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub »

Just as information, this has to do how OTRS handles data-arrays. For reasons I do not understand, the first entry ( [0] ) is undefined, thus one has to access the second one ( [1] ) explicitly.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
amdkryn
Znuny expert
Posts: 187
Joined: 02 Oct 2012, 02:52
Znuny Version: 5.0.27

Re: CMDB Overview columns

Post by amdkryn »

sampson wrote:I solved the problem by putting:

L::Phone::1

For any custom fields added to CMDB class, by including the "::1" to the "Key", the column will be included correctly.

Regards,
Sampson

Thanks for sharing this information. Now I was able to show the fields that I wanted.
OTRS version 5.0.27 (With ITSM), Operating System OpenSuse 12 with Mysql.
FlippieUSM
Znuny newbie
Posts: 1
Joined: 01 Nov 2018, 14:10
Znuny Version: OTRS6

Re: CMDB Overview columns

Post by FlippieUSM »

Hi all,

I'm currently testing with OTRS6 Business Solution with added CMDB.
The CMDB works default, but I'm not able to find the setting that is used in this post.
Anyone able to help me to show more columns in the CMDB overview?

Kind regards
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: CMDB Overview columns

Post by root »

FlippieUSM wrote: 08 Nov 2018, 16:01 I'm currently testing with OTRS6 Business Solution with added CMDB.
The CMDB works default, but I'm not able to find the setting that is used in this post.
Hi,

You should contact the vendor, AFAIK OTRS 6 comes only with support. And if you're still testing this is a good test for the support too. I think this should be the part in the System Configuration:
2018-11-08 at 3.53 PM.png
- Roy
You do not have the required permissions to view the files attached to this post.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Post Reply