Another interesting task came up, which is a continuation of one of the previous ones. It was necessary to create a script that would remove attachments from old past meetings. The script is based on the same approach as before — attachments will be removed using EWS. Accordingly, the account running the script must have…
How to download and install Office 2024 LTSC
An example of how to download and install Office 2024 LTSC, Visio, Project and Skype for Business. You can view the list of product codes here. Configuration options are available here. If it complains that it cannot download, you can try doing this: I chose TSForge from the menu.
How to Collect Statistics on User Calendar Events Using a Script?
Recently, I received a highly non-standard request — a client with Exchange Server 2016 and Skype for Business 2015 needed to collect statistics on user calendar meetings. The goal was to gather data on what meetings were scheduled, who was the organizer and who the participants were, whether any attachments were included in the meeting…
How to Audit Seafile: SQL Scripts to Get User, Repository and Access Information
I needed to audit a personal Seafile cloud storage instance. Unfortunately, the web interface doesn’t provide a convenient way to export lists of users, repositories, etc. all at once. Therefore, I decided to extract all necessary information directly from the databases, as the structure is simple and there aren’t too many tables. While the built-in API could have been used, in this case I found the direct database approach simpler.
Analyzing SMTP Logs in Microsoft Exchange with PowerShell
Some time ago, it became necessary to significantly modify the default Microsoft Exchange 2016 connectors related to authentication. After making these changes, it was essential to ensure they were functioning correctly and identify potentially problematic clients. To achieve this, I created a small script to analyze logs from all Exchange servers in the organization. I decided to save it here, as it can be useful to have an example of large-scale data collection from multiple servers at hand.