Converting WSA Logs into .csv

[mehedimec]

Hi Team,

How can i convert the WSA logs into a .csv file? My intention is to create a data-set in a single .csv file with specific information from the log files over a period of time. 

Thanks.

[Ken Stieers · Accepted solution]

They are all ready CSV, just rename them.

Keep in mind they are huge (10g)... and your tools may not be able to handle them

You may want to create a new log subscription with just the fields you need and then have that set up to export out to an ftp site or whatever...

[balaji.bandi]

Agreed the file already comma seperated one, but i do not belive EXCEL with stand with 10GB CSV file, i would rather make script to get based on the inputs and make them small CSV files.

As i was suggested other post, these files are huge and they need to get tuned based on the requirement.