Microsoft Flow - Renaming Files in SharePoint Online using Flow

So your looking to use Flow and rename some files in SharePoint. Too easy, but wait - there are no actions available to allow a rename? So what's next!? Well here we go, REST API to the rescue! But not so fast, there are some catches. You create a "Sent an HTTP request to SharePoint" action and fill in the properties as follows Site Address = Uri = _api/web/lists/getbytitle('<LIST NAME>')/getItemByStringId('<List Item ID>') Headers = { "X-HTTP-Method" : "PATCH" , "If-Match" : "*" , "Content-Type" : "application/json;odata=verbose" , "Accept" : "application/json;odata=verbose" } Body = {'__metadata': {'type': 'SP.Data.Project_x0020_DocumentsItem'}, 'Title':'test', 'FileLeafRef':'test.bmp'} The above can be created in the activit

Hotfix Strategy in Git

Git branching is usually pretty straight forward and although merging can be a hassle it is important to remember the reasons for the isolation. In the event a hotfix is required, it is handy to branch off from master instead of develop - this way we can test the fix on the develop branch before merging back to master. The beauty of this makes git so powerful and the reason it's the most popular software version control software at the moment. Also a quick mention that git branch --merged to see what's now part of the new master as this will list each individual feature, bugfix or hotfix as a list. Great for generating release notes.

SysInternals for File Handle Issues

An oldie but a goodie. Win32 IO Exceptions easily ciphered. Use filers on PID and filter out SUCCESS to focus on failures only.

WinDBG on 32Bit Applications

On a 64-bit Windows installation is it possible to make both 32-bit and 64-bit dumps of 32-bit processes. The task manager will create a 64-bit dump, which therefore is often what you end up with users sending you. This is not a problem for native executeables since you can still load it in windbg and use the !wow64exts.sw extension to switch into the 32-bit view. However if your process is a .NET process and you want to use SoS to investigate it then you are out of luck, you'll just get the message "SOS does not support the current target architecture." This extension gets around this by hooking/patching functions in dbgeng.dll so that SoS thinks it's working with a 32-bit dump. ** Usage ** Copy soswow64.dll into the "winxp" subfolder of windbg. Then after loading a 64-bit memory dump of a 32-bit process you can simply load the extension: 0:000> .load soswow64 Successfully hooked IDebugControl::GetExecutingProcessorType. Successfully patched DbgEng!X

WinDBG Standalone Installers

As with previous posts, using WinDBG for .NET Debugging between .NET IL and Win Kernal is the perfect tool to expose exception data. Download WinDBG Standalone

mRemoteNG - Simplify infrastructure management

Great new feature of mRemoteNG is the ability to add webpages to the treeview. Perfect for admin pages, one stop shop for your SSH, RDP, Telnet and HTTPS admin portals. There is a bug where it won't open Firefox if the cert is self-signed. To resolve: Manual fix to use your firefox exception SSL w/invalid certs: Copy: c:\users%USERNAME%\AppData\Roaming\Mozilla\Firefox\Profiles{RANDOM}\cert_override.txt and place it here c:\users%USERNAME%\AppData\Local\Geckofx\DefaultProfile\cert_override.txt Windows 2012 R2 warning - Gecko only works on mRemoteNG 1.75 - it is not working yet on 1.76. Reference: https://github.c om/mRemoteNG/mRemoteNG/issues/259

GREP in PowerShell

Simple but powerful script to search recursively through a windows directory searching for a string of text. PS C:\> get-childitem "C:\*" -recurse | select-string -pattern "what your looking for"