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
$xml.WriteContentTo($XmlWriter)
$XmlWriter.Flush()
$StringWriter.Flush()
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