Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

Export ClearPass Endpoints to Excel

This thread has been viewed 6 times

  • 1.  Export ClearPass Endpoints to Excel

    MVP
    Posted Apr 27, 2018 03:03 PM

    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?



  • 2.  RE: Export ClearPass Endpoints to Excel

    EMPLOYEE
    Posted Apr 27, 2018 03:21 PM
    What is the end goal for the data?


  • 3.  RE: Export ClearPass Endpoints to Excel

    MVP
    Posted Apr 27, 2018 03:33 PM
    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.