CMDB Overview columns

Moderator: crythias

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

CMDB Overview columns

Post by lmasal » 25 Jan 2015, 13:19

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
OTRS guru
Posts: 2052
Joined: 13 Mar 2014, 09:16
OTRS Version?: 5.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub » 26 Jan 2015, 10:27

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 5.0.14 -- MariaDB -- Ubuntu 16 LTS

lmasal
OTRS newbie
Posts: 6
Joined: 10 Jul 2014, 09:21
OTRS Version?: 3.3.8

Re: CMDB Overview columns

Post by lmasal » 27 Jan 2015, 08:54

Hi, it worked.

Thanks for help. :)

Stevo
OTRS newbie
Posts: 16
Joined: 25 Nov 2013, 11:59
OTRS Version?: 3.3.7

Re: CMDB Overview columns

Post by Stevo » 03 Feb 2015, 15:28

Having done this, is it possible to make the added columns sortable?

RStraub
OTRS guru
Posts: 2052
Joined: 13 Mar 2014, 09:16
OTRS Version?: 5.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub » 04 Feb 2015, 10:18

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 5.0.14 -- MariaDB -- Ubuntu 16 LTS

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

Re: CMDB Overview columns

Post by sampson » 18 May 2015, 11:31

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
OTRS newbie
Posts: 2
Joined: 18 May 2015, 11:17
OTRS Version?: 4.0.7
Real Name: Sampson Fung
Company: The Executive Centre

Re: CMDB Overview columns

Post by sampson » 18 May 2015, 12:08

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
OTRS guru
Posts: 2052
Joined: 13 Mar 2014, 09:16
OTRS Version?: 5.0.14
Real Name: Rolf Straub

Re: CMDB Overview columns

Post by RStraub » 19 May 2015, 08:28

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 5.0.14 -- MariaDB -- Ubuntu 16 LTS

amdkryn
OTRS wizard
Posts: 185
Joined: 02 Oct 2012, 02:52
OTRS Version?: 5.0.27

Re: CMDB Overview columns

Post by amdkryn » 16 Mar 2016, 22:02

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
OTRS newbie
Posts: 1
Joined: 01 Nov 2018, 14:10
OTRS Version?: OTRS6

Re: CMDB Overview columns

Post by FlippieUSM » 08 Nov 2018, 16:01

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
Moderator
Posts: 1314
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: CMDB Overview columns

Post by root » 08 Nov 2018, 16:54

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.
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

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

Post Reply