Download and install latest Office 365 via Office Deployment Tool (ODT)

Inspired by Trond Eric Haavarstein’s evergreen PowerShell setup scripts, I created a download and install script for Office 365 Deployment Tool (ODT).

Microsoft Office 365 is the new standard in the EUC space right now. To honor this, we need a fast and reliable way to install it with our favorite deployment tools like MDT or PDQ,  for example when you rebuild your master images.

There are a few different ways to deploy Office 365, but they are all similar:

  • You need the Office 365 Click-to-run setup.exe (Office Deployment Tool (ODT))
  • You need a XML configuration file
  • You decide to deploy from a pre-build offline cache or the files are downloaded from Microsoft each and every time

And then you go: setup.exe /configure configuration.xml

Pretty straight forward you think, but non the less I had problems with this approach. And this is due to the fact, that the Office Deployment Tool itself gets updated pretty often. And this breaks your unattended deployments sooner or later, as the setup.exe stops working. Continue reading “Download and install latest Office 365 via Office Deployment Tool (ODT)”

Installing the Microsoft ODBC Driver for SQL Server on Debian Linux with Saltstack

Installing the Microsoft ODBC Driver for SQL Server on Debian Linux (msodbcsql17) with Saltstack requires to pass ACCEPT_EULA=Y to the package manager. This blog post shows a possible solution.

Introduction

Microsoft offers several open source utilities for quite some time now. One is the Microsoft ODBC Driver for SQL Server on Linux which can be leveraged with unixodbc. In my case, I need this driver to query Microsoft SQL Server for my Zabbix ODBC monitoring, to execute native SQL queries for monitoring purposes. As I have to take control over 30+ Zabbix Proxies, I’m currently transforming all of them into Salt minions. My goal here is to achieve 100% automation, as soon as I install the Salt minion on a fresh Debian Linux. Continue reading “Installing the Microsoft ODBC Driver for SQL Server on Debian Linux with Saltstack”