Carbon Black Cloud: How to find Duplicate Names
book
Article ID: 285009
calendar_today
Updated On:
Products
Carbon Black Cloud Endpoint Standard (formerly Cb Defense)
Issue/Introduction
How to find Duplicate Names.
Environment
- Carbon Black Cloud Console: All Versions
Resolution
- Go to Endpoints Page or VM Workloads Page.
- Export the Device information by clicking the Export button.
- Open the exported device information csv format file in excel.
- Add 2 columns Duplicate and Duplicate Count to the end of the table.
- For Duplicate column use formula =COUNTIF(AG:AG,AG2)>1 and for Duplicate Count use formula =COUNTIF(AG:AG,AG2)
- Use the Filter functionality to filter rows having Duplicate column value as True. These are the devices with Duplicate Names.
- 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 Information
AG in the formula equals the "name" column, if the results are not as expected please verify column is still correct.
Feedback
thumb_up
Yes
thumb_down
No