CMDB Overview columns
Moderator: crythias
CMDB Overview columns
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.
Thanks.
You do not have the required permissions to view the files attached to this post.
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: CMDB Overview columns
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.
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
Re: CMDB Overview columns
Hi, it worked.
Thanks for help.
Thanks for help.
Re: CMDB Overview columns
Having done this, is it possible to make the added columns sortable?
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: CMDB Overview columns
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:
If you take then a look at the mentioned ticket search, it reads:
So it seems to be possible, but I cannot provide a working code.
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,
};
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
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
-
- 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
I created a new Class "L" by copying the default "Location" class.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.
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
-
- 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
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
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
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: CMDB Overview columns
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
Re: CMDB Overview columns
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.
-
- Znuny newbie
- Posts: 1
- Joined: 01 Nov 2018, 14:10
- Znuny Version: OTRS6
Re: CMDB Overview columns
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
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
-
- Administrator
- Posts: 3968
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: CMDB Overview columns
Hi,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.
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:
- 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 ?
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 ?