App Control: CSV Export of Hostnames can show Scientific Notations
book
Article ID: 288973
calendar_today
Updated On:
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.