App Control: CSV Export of Hostnames can show Scientific Notations

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

An issues exists if a hostname has a "<number>E<number>" format, the export in .csv format can show the hostname in scientific notations. An example would be: host name 2E4 becomes 2.00E+04.

Environment

• App Control Server: All Supported Versions
• Microsoft Windows: All Supported Versions
• Microsoft Excel: All Versions

Cause

Due to how Microsoft Excel handles output of the "<number>E<number>"  value. If opened in Microsoft Excel, the scientific notations will be superimposed over the original hostname.

Resolution

Open the App Control CSV output in a text editor to get proper hostnames.