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.
