Security

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?

What is the end goal for the data?

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.