Hi,
I am excited to submit my proposal for creating an efficient method to generate monthly log reports on Windows.
Proposed Method
To create the monthly log reports efficiently, I propose the following approach:
1. Data Collection:
• PowerShell Scripts: Utilize PowerShell to collect event logs for sign-in, sign-out, and specific activities. This method allows for detailed customization and scheduling.
• Windows Event Viewer: Leverage the Event Viewer to filter relevant events, capturing log entries for application launches and other activities within the specified time frame.
2. Automation:
• Task Scheduler: Implement Windows Task Scheduler to automate the execution of the PowerShell script. This will ensure logs are collected daily, Monday to Friday, excluding Japanese public holidays, at the specified times.
• Logging Deviations: Include functionality in the script to record 1-10 minute deviations from the specified times, ensuring accuracy in the log reports.
3. Data Format and Storage:
• Log Format: Store logs in Windows Event File format for easy integration with existing systems.
• Storage Location: Use either local storage or cloud solutions, such as OneDrive or Azure Blob Storage, to ensure accessibility and backup.
4. Feasibility Assessment:
• Begin by collecting logs for one user to evaluate the effectiveness of the method. Based on initial results, scale up to accommodate logs for up to 40 users with minimal adjustments.