Power shell Script to ping devices and send it in the form of an email and also save to csv file

I have a list of host devices along with their IP address. I want 2 Power shell Script to ping devices and send it in the form of an email to 4 clients (one every 24 hours) and also save the results in a CSV file. The two scripts should be for a) Status of all devices over the past 24 hours and publish the stat on % success/failure(in colored format) over the last 24 hours for the email report. The device should be pinged every hour. b) For the CSV File, the following information should be present. Host ID IP Address Reply IP Address Succeed Count Failed Count Consecutive Failed Count Max Consecutive Failed Time % Failed Last Ping Status Last Ping TTL Last Ping TTL Average Ping Time Description Last Succeed On Last Failed On Minimum Ping Time Maximum Ping Time