Note that there are no checks in place to determine if there are duplicates. The same data is then appended to data that already exists in the pexHistor圜onf.csv and # These files are named yyyy-mm-dd_hh-mm-ss_pexHistor圜onf.csv and yyyy-mm-dd_hh-mm-ss_pexHistoryPart.csv to
![powershell unzip powershell unzip](https://www.mobigyaan.com/wp-content/uploads/2020/06/powershell-zip-1024x210.png)
# history of all conferences and their participants between the time the script is run and the previous 24 hours.
![powershell unzip powershell unzip](https://www.thewindowsclub.com/wp-content/uploads/2020/07/Zip-and-Unzip-files-using-PowerShell-8.png)
# Each time it runs it creates 2 new csv files in the directory the script is run from. # A simple Powershell script that downloads conference and participant history from the Pexip Management Node. Note that you need to manually run the script at the same time each day, or schedule it to automatically run at the appropriate intervals.
#POWERSHELL UNZIP HOW TO#
The following sections show to use a PowerShell script to extract and accumulate historic data, how to examine that extracted data in Excel, and how to set up PowerBI with the Pexip Management Node as the data source. If data is required past this number of records then the information needs to be taken from this database at regular intervals.
![powershell unzip powershell unzip](https://i1.wp.com/pureinfotech.com/wp-content/uploads/2019/04/unzip-extract-files-powershell-windows-10.jpg)
Note that the database that holds this information stores historic data for up to 10,000 conferences (including the participant history for all these conferences). First you need to load the assembly ZipFile is in: ::LoadWithPartialName ('System.IO.Compression. You should be able to use this from PowerShell. Using the history API to extract conference and participant information Server 2012 comes with Dot.NET 4.5 which has System.IO.Compression.ZipFile which has a ExtractToDirectory method.The following background information is available: