PowerShell to query local Windows Search index (e.g., for Visio shapes)

Get-WindowsSearchIndexResults.ps1

$contents = "Virtual"
$sql = "SELECT System.ItemName, System.ItemUrl FROM SYSTEMINDEX WHERE Contains(*,'$($contents)') AND System.ItemType='.VSSX'"
$Provider = "Provider=Search.CollatorDSO;Extended Properties=’Application=Windows’;"
$adapter = new-object system.data.oledb.oleDBDataadapter -argument $sql, $Provider

$ds = new-object system.data.dataset

if ($adapter.Fill($ds)) { $ds.Tables[0] }