Sometimes one of your databases is eating up diskspace, and you want to know why. By running the query below, you can easily view the number of rows for each table (and can even sort so that the tables with the most rows are on top). USE BizTalkDTADb –USE BizTalkMgmtDb SELECT sc.name +'.'+ ta.name TableName […]
Normally, I would call a static method in a C# library rather than coding this in a functoid. It’s easier to unit test, you get full Intellisense (automatic code completion), and it just seems easier. However, I’m at a new client, that doesn’t yet have a C# library. It’s really no big deal to add […]
I wasted almost two hours on this today. The goal was simply to create a function to pull out a 5 digit zip code from a string. Three Powershell lessons learned : 1) using -match will return an additional $true/$false from a function unless you “swallow” the value into a variable. http://stackoverflow.com/questions/27193956/extracting-data-from-the-matches-hashtable-after-a-powershell-regeg-match 2) return doesn’t […]
Powershell Code: # # LUNAR DUST – home grown server/service monitor – sends out email when services defined in related .CSV config file are down # Author: Neal Walters – Nov 2013 # (Lunar Dust is a play on words of the monitor name “Solar Wind”) # [string[]] $users = “john@abc.com”,'”fred@abc.com” # List of users […]
get-service | where {$_.name -match "win"} Normally displays like this: Note how very long names can get cut off with the ellipses…. Did you know that Powershell has a “grid-view”, similar to SQL? get-service | where {$_.name -match "win"} | out-gridview If you pipe all get-service to the out-gridview, then you can see how you […]
This is basically a follow-up to the previous post How to add a where filter match/contains/like to any powershell cmdlet (such as Get-Service) Cmdlets are named in the format “verb-noun”, for example get-service, start-service, etc… Suppose you cannot remember all the verbs associated with a noun. You can run this: get-command -Noun process Recall from […]
Sometimes, when property names contain very long values, the default displays cuts part of the name, as shown with this command and its output. [“ellipsis” is the term for the … when a name is truncated] as shown in the example below: get-service | where {$_.name -match "win"} | sort-object Status -desc Simply pipe the […]
get-process | {$_.name -match "win"} Sample output is shown below. The above means “get all the process objects on this computer” and pipe that collection of objects to a where/filter where we only want to see processNames that contain the letters “host”. Example output: Handles NPM(K) PM(K) WS(K) VM(M) CPU(s) Id ProcessName ——- —— —– —– —– —— — ———– 75 8 796 […]
The purpose of this script is to monitor disk space on a list of servers. Right now, it uses a hard-coded 20% as the point at which to send the email (look for variable $thresholdspace in the code below). An enhancement could be to have different percents on each server. The script reads a file […]
Maybe a VP at works ask you “What is BizTalk”? Can you give him a quick answer? As a Dallas BizTalk Consultant, do you have a hard time explaining what you do for a living to your family and friends? Maybe this video will help. Using the Parker Brothers game called “Watersworks Leaky Pipe Card […]