Is it possible to trim the field values before sending Report without making changes in CMDB table?

[Suvetha S]

Hi all,

I have created a weekly report with details from Server table like Name, Host Name, Discovery source etc.,. I noticed that few servers have additional @virtual server and hostname has domain name .XXX.com. I wanted to check if there is any way to remove those values (without updating them in the cmdb table) before sending report? Please advice

[Maik Skoddow]

Hi  @Suvetha S 

one option would be creating report function fields which prepare the value accordingly and then to report on these fields instead of the original fields: https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/concept/function-fi... 

Maik

[Suvetha S]

Hi @Maik Skoddow 

Can we achieve it with help of scripting?

[ersureshbe]

Hi, If it's a major expectation you can achieve it through Database View and define conditions to trim the value. For any reason, custom attribute allows to creation of an inside OOB form you can define simple business rules and populate the value in a custom field.