Thursday, December 7, 2017

How to create WFA datasources with Python, c# or any other language

A colleague of mine had an issue with one of his datasources.  The issue wasn't the point, it was how he had created the datasource that was inspiring.  He actually created his CSV files outside of WFA and then in his datasource just copied them in.

$qtree_export_policy = "D:\WFA_Datasources\Qtree_Export_Policy.csv"
Get-WFALogger -message("Grabbing the file - " + $qtree_export_policy)
Copy-Item $qtree_export_policy .\

This made me think...

Monday, November 27, 2017

Self Healing Fabric with OCUM & WFA

Who doesn't love the concept of a self-healing system.  But what is self-healing ?  How can it be accomplished.  And can I make it fit my needs ?

In this "cookbook"-tutorial, you can find at least 1 method how it can be done.  But once you know the concept, the possibilities are nearly endless.

This idea is originally from Yaron Regev, so all creds go to him :).

Tuesday, November 21, 2017

Securely store credentials with powershell

I you have ever written PowerShell, you probably encountered the challenge that you need to store credentials for your script.  While debugging you probably hard code your credentials in your script, but once you have the script in production (manually or scheduled), you probably don't want them in the script in clear text.

This piece of code is pretty old but still does the trick.

Wednesday, November 8, 2017

How to create advanced workflows


Hi there,

so you like WFA and you want to learn more ?  Then chances are this tutorial is one for you.
This is also an non-branded recording of my Netapp Insight Session : 12721-3 - Learn How To Make Advanced Workflows at Insight Las Vegas - Berlin 2017.

This is the agenda :

1) Schemes and Dictionaries
2) Datasources
3) Debug WFA Powershell
4) Remote Powershell Sessions
5) Scripted Datasources
6) SQL Datasources
7) Custom Command + Reservations
8) RBAC & AD
9) Functions
10) Advanced Logging
11) Backup & document WFA

Thursday, October 12, 2017

Tutorial : Use Wfa as a self-service portal


In my previous post, I have shown you my package on how to abstract user-input and how that allows you to create more user-friendly workflows.

In this youtube tutorial we are diving into that package and have a look what it does and what it can mean to you. download the sample excel from this demo

Tuesday, October 3, 2017

How to use WFA as a self service portal

If you ever thought about using WFA as a self-service portal, I'm sure you have bumped into a few challenges on how to make it user friendly.

If you want to design a good a userinput form, the absolute number 1 rule is "KISS" (keep it short and stupid).  So if you are going to present an operator or end-user with a short and simple input form, how can it kick off a long and complex workflow ?  If you want to omit all the technical information and decisions from the operator, how can WFA know what resources to pick ?

Wednesday, September 20, 2017

How to create workflow independent constants in WFA

If you're working with WFA for some time, you'll probably be using Constants.  And you should ! The problem is that constants are part of your workflow.  If you're a bit of a good developer, you should develop for re-usability and that also means that certain parameters should be externalized.  Settings like customer information (dns servers, domain names, etc...) are a perfect fit for an externalized constant. 

Let's have a look at our possibilities

Thursday, September 7, 2017

WFA Docs generator 2.0

A new WFA Doc generator with most features you'll want :
- No need for installing Word
- Creates documents for :
   - Workflows
   - Commands
   - Scheme's, dictionaries & datasources


WFA workflow - Install PSExcel and PSWord

When you want to work with Excel and Word documents from within WFA, you either choose to install Excel and Word, or, way better, you choose for the PowerShell Modules
- PSExcel
- PSWord

This workflow will install these for you on the WFA server on the right location.  The actual source files are safely hidden in the help content of the workflow.


Wednesday, August 30, 2017

Manage DFS from WFA (W2012+)

I already created a post for managing DFS, but that was for W2008 servers, where it still has to be done with dfsutil.exe.
Since 2012 there is better way.
DFS or Distributed File System, is often used in enterprise environments to virtualize your CIFS tree structure.  If you are automating storage, and if so, CIFS, you might also take it a little further and update your DFS.  This powershell code allows you to add/create, remove & offline/online your dfs links and target shares and get the targets of dfs link.