Ich habe die folgende aufgabe zu lösen und brauche hilfe.

Logging Aggregator and Reporting:
Imagine a fitness studio chain that operates different studios in Munich. Every studio has been given a Windows server that operates the entry of studio clients via a key-card (NFC) and it also operates the cashier at the bar where beverages are and snacks are sold.

The management of the chain wants to get a better overview of the daily activity in all of their studios (4 at the moment and a 5^th one being prepared for the grand opening). Therefore you have been given the task to retrieve the log files from each of the servers copy them to a central aggregation server, read those files, merge them if necessary and send an email with a report once a day to the management.


Servers The following servers are in operation at the moment
\\Server1
\\Server2
\\Server3
\\Server4

Every of these servers has a user names “Aggregator” which has the password “gimme_data” and which has the rights to read the log files.

Services Each server runs 2 services
Check-In – writes a log-entry for each “check-in” of a client
Cashier – writes a log-entry for each sale at the bar
Log Files

Each services creates a rolling file for the actual hour and writes all the log entries during this hour into this file. At the beginning of a new hour a new file is created and then used for writing the log entries into it. So for every day you will have a maximum of 24 log files per service (a total of max 48 log files for 2 services)
The log files for the checkin can be found at this relative path c:\logs\sevices\check-in\<reverse-date>\<hour[always 2 digits]>.txt Example: for the studio at Server1 you will find the file for the cashier for the period of September 10^th 2014 from 15:00 to 15:59:59 at \\Server1\C\logs\services\cashier\2014-09-10\15.txt
Logging Entries The logging entries have the following format

Check-in => <timestamp>,<user-id-read-from-key-card><CR> Example: 14:34:51, 2932 14:39:22, 1922 15:12:09, 0976
Cashier => <time-stamp>, <user-id>, <beverage|snack>, <amount><CR> Example: 16:34:51, 2235, beverage, 13.12 17:23:22, 0127, snack, 7.23 17:48:09, 0976, beverage, 17.91

Line endings are denoted by <CR Carriage Return>. Fields are split by commas

Aggregation Server The aggregation servers has the following tasks
Copy each file from each of the servers to the aggregation server itself.
The path to copy the files is the same as on the original servers => path c:\logs\sevices\check-in\<reverse-date>\<hour[always 2 digits]>.txt
Rename the file(s) so that every file has the name of the server origin in it. Example: path c:\logs\sevices\check-in\2014-09-10\17-Server1.txt
Create a file that merges all files from all servers into on for each day. Name that file total.txt. Do this for the check-in and cashier service Example: c:\logs\sevices\check-in\2014-09-10\17-Leopold.txt 17:34:51, 2932 17:39:22, 1922 c:\logs\sevices\check-in\2014-09-10\19-Leopold.txt 19:22:51, 4132 19:31:22, 9122 c:\logs\sevices\check-in\2014-09-10\15-Server4.txt 15:51:51, 2222 15:99:22, 1222 c:\logs\sevices\check-in\2014-09-10\19-Server4.txt 19:12:51, 7332 19:19:22, 3522 Should result in a file name c:\logs\sevices\check-in\2014-09-10\total.txt that contains the following data 17:34:51, 2932 17:39:22, 1922 19:22:51, 4132 19:31:22, 9122 15:51:51, 2222 15:99:22, 1222 19:12:51, 7332 19:19:22, 3522
Report

Send an email to admin@hotmail.com and attach both “total” files for the check-in service and the cashier-service.

Use Powershell to write the script

type dateien*.txt>toptal.txt

type dateien*.txt>toptal.txt
>