Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Carbon Black Cloud: How to find Duplicate Names

Carbon Black Cloud: How to find Duplicate Names

Environment

  • Carbon Black Cloud Console: All Versions

Objective

How to find Duplicate Names.

Resolution

  1. Go to Endpoints Page or VM Workloads Page.
  2. Export the Device information by clicking the Export button.
  3. Open the exported device information csv format file in excel.
  4. Add 2 columns Duplicate and Duplicate Count to the end of the table.
  5. For Duplicate column use formula =COUNTIF(AG:AG,AG2)>1 and for Duplicate Count use formula =COUNTIF(AG:AG,AG2)
  6. Use the Filter functionality to filter rows having Duplicate column value as True. These are the devices with Duplicate Names.
  7. Copy the list of Duplicate Device names to new sheet. Go To Data->Remove Duplicates. This is the list of Device Names having duplicate value.

Additional Notes

AG in the formula equals the "name" column, if the results are not as expected please verify column is still correct. 

Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-22-2022
Views:
465
Contributors