Thanks to Chris Ross of SCSM.US for sharing this great information!

Here are a few little queries you can use to get some good information for use within ServiceMgr:

From SQL if you want to view a MP’s xml…


function Format-XML ([xml]$xml, $indent=2)
    $StringWriter = New-Object System.IO.StringWriter
    $XmlWriter = New-Object System.XMl.XmlTextWriter $StringWriter
    $xmlWriter.Formatting = "indented"
    $xmlWriter.Indentation = $Indent
    Write-Output $StringWriter.ToString()


From PowerShell if you want to find info on a specific projection type…

#Get TypeProjection
$tp = Get-SCSMTypeProjection System.WorkItem.Incident.ProjectionType
#Formt the output
Format-XML $tp.GetAsXml().InnerXml