Snowflake have developed a simple command line tool that can be used to investigate snowflake connectivity issues. This tool's full name is the Snowflake Connectivity Diagnostic Tool, however it is more commonly referred to as SnowCD. If you are seeing connection issues with Snowflake, I would...
SSH-Agent and OpenSSH are tools in Windows that can be used to authenticate to remote Git repositories, such as GitLab, GitHub, Azure DevOps, etc. Once set up as a service that stores your various SSH keys, this can facilitate authentication without entering a password each...
Question: I need to script tabcmd commands but can't leave passwords in plaintext inside scripts! How can I script tabcmd commands securely? The Challenge Tabcmd requires a username and a password passed to it in order to log into a Tableau Server site. While this is fine...
Note: This blog was updated in October 2023 with minor updates. Our previous post in this series explained how to import data via the Snowflake user interface. You can also stage your data and load it into tables with code via SnowSQL, which is what this blog...
Whether starting recon on a new client’s environment or migrating a long-term client’s data to new servers, it sometimes is necessary to know some basic information on the user accounts listed in Active Directory. Recently, I was installing new servers for a public school, and part...
When investigating an existing domain for a potential upgrade or clean-up, it’s necessary to gauge the number of Active Directory (AD) objects in order to decide how many domain controllers are needed. This is also just useful information to occasionally check in order to keep...
Many of us heavily rely on our digital calendars to organize our schedules, and with those often come third-party conferencing products such as Webex, GoToMeeting and a myriad of others services to help accommodate these needs. However, we recently came across an issue where one of...
As Tableau Developers, we hate to see our work flattened and shoved into a PowerPoint file. We love to see our work displayed in it's fullest, greatest ways - full of filters, parameters and tooltips for our users to play around with. Occasionally, though, we have a few...
This post builds off of two great previous posts about Tabcmd by Kate Treadwell and Tanner Ladd. Please refer back to these posts if you have questions about setting up Tabcmd and distributing PDFs. The goal of this post is to show you how to use...
After recently deploying a hybrid configuration for Office 365, many email settings that were easily configurable within Office 365 portal could not be changed as these settings were being managed by on-premise Active Directory servers. To get past this restriction, the next best option is...
Here is a quick PowerShell script to help you query the last logon time for all of your users across all of your domain controllers. It will also save the output to a .csv file specified in the $exportFilePath string. I was surprised not to find...
I’m three months in to my career at InterWorks and think it’s high time for my first blog post. In this post, we’ll cover the basics of using PowerShell and Tabcmd to distribute PDF files of your Tableau views via email. I have to give...
This is part 2 of my mini-series on exploring Tableau workbooks with PowerShell. If you missed it, you should read Part 1: Opening Workbooks, before continuing. Welcome back! Last time I showed you how to open a Tableau workbook (TWB or TWBX) in PowerShell so you...
In this mini-series I'm going to show you some cookbook style examples for using PowerShell to explore your Tableau workbooks. Follow along, this is going to be fun! Tableau workbooks (TWB files) are just XML files. Packaged workbooks (TWBX files) are just ZIP files that contain...
Is your Tableau extract done? Don’t wait to find out! Send yourself (or a group) an email. If you haven’t already, make sure you’ve done this and this. Oh, and make sure you’ve got PowerShell v3 installed. Done? Perfect. Let’s get to the fun stuff. We’ll be...
I recently worked on a quick and dirty Powershell script to send me email notifications when content on a web page changed. To send the email, I also went for the quick and dirty method and just used SMTP with my Gmail account. After I...
Your ‘To-Do’ list: We’ll use Oracle for this example. In future posts, I’ll discuss other databases (including SQL Server). Download and install the ODAC (Oracle Data Access Components) from here. Make sure you have PowerShell v3 installed. Step 1: Set up the link between PowerShell and Oracle Copy the attached...
Question: Of all the workbooks on Tableau Server, which (1) use a Tableau Server data source and (2) what workbook(s) use them? Answer: Since there’s no simple and straightforward way to extract this information from the default views on Tableau Server (_datasources, etc.), we’ll...
Usually it is best to configure your terminal service policy to log out disconnected sessions, however there may be cases where you only want to kill specific applications when the user disconnects. This is easy to do with a PowerShell script that you run periodically as...
Scripting Tips is an on-again-off-again series for command line fiends. I'll try to keep these short and sweet. To dig a 'lil deeper you can find me on Twitter. I'll cover these prerequisites in brief, but for this tip I'm going to assume a...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072