When using the SMDigest for deployments you ignore the p1: in front fo the fileds. IT is just a namespace and does not get parsed.
Maik is the xml master... That guy is freakishly smart. On Wed, May 22, 2013 at 8:30 PM, Marcum, John <[email protected]> wrote: > XPath? Jason did a demo of that at MMS. I am DYING to learn to use it. > Love how you can finally make all info about a machine display in a single > row in a report. For example all the stuff in ARP. > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Todd Hemsell > *Sent:* Wednesday, May 22, 2013 10:47 AM > *To:* [email protected] > *Subject:* [mssms] SQL XQuery Help > > > > I am trying to figure out how to write an XQuery to get the install and > uninstall command out of the SDMDigest for a Deployment and not having much > luck. > > > > Luethold wrote the first example of getting an apps user and contact, but > for the life of me I am unable to recreate that in the DepploymentType SDM > > XQuery Reference http://msdn.microsoft.com/en-us/library/ms189075.aspx > > > > > > Here is the example Luethold wrote and I am trying to convert to get the > values shown below > > > > SDMPackageDigest.value('(/AppMgmtDigest/Application/Owners/User/@Id)[1]', > 'nvarchar(MAX)') [Owner], > > Here is a snippet of the XML from the SDM. > > > > <AppMgmtDigest xmlns=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest > " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > > <p1:DeploymentType xmlns:p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest > " AuthoringScopeId="ScopeId_62BA06EA-054D-4736-9FA5-F4734D1FBA6A" > LogicalName="DeploymentType_31a6ee3b-acf6-41b8-9ea9-7c964c9091b0" Version= > "3"> > > <p1:Installer Technology="Script"> > > <p1:InstallAction> > > <p1:Provider>Script</p1:Provider> > > <p1:Args> > > <p1:Arg Name="InstallCommandLine" Type="String">FindMe.exe</p1:Arg> > > </p1:Args> > > </p1:InstallAction> > > <p1:UninstallAction> > > <p1:Provider>Script</p1:Provider> > > <p1:Args> > > <p1:Arg Name="InstallCommandLine" Type="String">FindMe.exe</p1:Arg> > > </p1:Args> > > </p1:UninstallAction> > > </p1:Installer> > > </p1:DeploymentType> > > </AppMgmtDigest> > > > > > > > > > > > ------------------------------ > > > Confidentiality Notice: This e-mail is from a law firm and may be > protected by the attorney-client or work product privileges. If you have > received this message in error, please notify the sender by replying to > this e-mail and then delete it from your computer. > > ------------------------------ > > Confidentiality Notice: This e-mail is from a law firm and may be > protected by the attorney-client or work product privileges. If you have > received this message in error, please notify the sender by replying to > this e-mail and then delete it from your computer. > >
