Monthly Archives: March 2014

Wireshark – Extract Video from Capture File

Wireshark is one of my most favorite tools because it is extremely powerful but not too complicated to use. Most of the time when I use Wireshark I use it to simply analyze network traffic at work but today I will show you one of the lesser known features of it: Extracting videos from capture files. While this feature might be quite useless at work it might be useful for you at home. (The same steps can be performed to retrieve any kind of file so it could be useful at work too.)

Enough small talk for now letĀ“s get down to business šŸ™‚

Install Wireshark on your computer

The first step is to install Wireshark on your computer since we will need it to capture your network traffic and save it to a capture file. You can download Wireshark from here.

Run Wireshark

Now run Wireshark.


Start Capture

To start a capture go to Capture and click on Interfaces…


Now choose the network interfaces from which you want to capture its traffic. I chose my Wireless Network Connection. After you selected your network interface click on Options.


Now all you need to do is to select a file where you want to store your network traffic capture. I stored my network traffic capture in the file “C:\test_capture”.


Now you are ready to start your capture. Click on Start.

Watch a video online

Now that your capture is running start the video stream you want to capture. For example: Watch aĀ video onĀ WatchOP or on any other website you know.

Important: It is very important that you start the Wireshark network capture before you start the video stream. Otherwise you will not be able to extract the video later.

When the video has finished playing you can stop the capture.


Extract the video

Now go to File -> Export Objects and click on HTTP.


Now search for the Content Type video.


After you found your video select it and click on Save As. As you can see in the screenshot above my video is from the file type mp4 so I will save it as a mp4 video file.

Test your video

To test your video I recommend to use VLC Media Player since it can play nearly every video file type.


ThatĀ“s it. You have successfully captured, extracted and tested your video. Pretty simple and useful, right?



SharePoint – Use SharePoint Columns in Microsoft Word (Create Forms)

Today I discovered that you can use SharePoint Columns in Word Documents to create simple Form Templates.

You can do this with Out of the Box features of the following applications:

  • Microsoft SharePoint (You need at least SharePoint Foundation)
  • Microsoft Office (At least 2007/2010)

Create a SharePoint Document Library

The first thing you need to do is to create a new SharePoint Document Library.


Create SharePoint Columns

Now fill your Document Library with Columns. For example: I created a column (Type: Single line of text) called LastName.


Edit Document Library Template

Now edit the default template of your Document Library and add the columns you created before.

First go to Library Settings then click Advanced Settings and finally click on Edit Template.




Now Microsoft Word will open up so you can edit the template.

Add Quick Parts

To use your SharePoint Columns in Microsoft Word you need to add them as Quick Parts. All you need to do is go to Insert and click on Quick Parts.


Now select Document Property and select the SharePoint column you created. For example: You can see my column LastName in the screenshot below.


Your finished Template may look like this:


Now save your Template and your work is done.

Fill out your new Template

To test your new template go to your Document Library and click on New Document.


Microsoft Word will open up and you can now fill out your newly created document. Your filled out document may look like this:


Now save your document and all changes you made will be saved to your SharePoint columns.

View Properties of newly created document

Now go to your Document Library and select your newly created document. Click on View Properties and you will see that your columns are filled with the data you entered in Microsoft Word. If you edit these properties the changes will be applied to your document as well.


ThatĀ“s it. Now you can use this technique to create Forms of all kinds and use the metadata in Views, Workflows, etc.



PowerShell – WellKnownSIDTypes

Today I learned about WellKnownSIDTypes. These WellKnownSIDTypes are useful if the company you are working for uses Microsoft Windows in different languages. For example: If you want to get the members of the Local Administrators group you cannot simply use “Administrators” because the name of the group will be different in each language. So how can you solve this issue? By using WellKnownSIDTypes of course.

Here is an example script that will retrieve the SID of the “Administrators” group for you:

#Get the SID of the Local Group "BUILTIN\Administrators"
function Get-BuiltinAdministratorsSID
$ID = [System.Security.Principal.WellKnownSidType]::BuiltinAdministratorsSid
$SID = New-Object System.Security.Principal.SecurityIdentifier($ID, $Null)

return $SID.Value

As always you can download the example script fromĀ here. If you want to know more about WellKnownSIDTypes please have a look at my sources.