Security

Reply

Export ClearPass Endpoints to Excel

Simple problem - Trying to export my ClearPass endpoints to a readible format (Excel) for sorting and filtering etc. I exported my endpoints, which comes across as a CSV file. File size is roughly 405MB, which I cannot import into Excel natively, it won't allow the file size. My option is to figure out an efficient way to do this or to break the entire file up into bits (about 30MB at a time) and import all seperately into Excel.

 

What's the best way to do this and what have others done?



Michael Haring
If my answer is helpful, a Kudos is always appreciated!
Guru Elite

Re: Export ClearPass Endpoints to Excel

What is the end goal for the data?

| Tim Cappalli | Aruba Security | @timcappalli | timcappalli.me |

NOTE: Answers and views expressed by me on this forum are my own and not necessarily the position of Aruba or Hewlett Packard Enterprise.

Re: Export ClearPass Endpoints to Excel

We're using ClearPass for network discovery and profiling. Need to provide list of endpoints including their MAC, IP, Fingerprint Data and Profiled info to customer for audit.


Michael Haring
If my answer is helpful, a Kudos is always appreciated!
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: