I think this is it.
Select Apps.DisplayName, Apps.CI_ID, C.ContentSource From fn_ListApplicationCIs(1033) Apps Left Join v_CIContentPackage CP on CP.CI_ID = Apps.CI_ID Left Join v_Content C on C.PkgID = CP.PkgID On Fri, May 31, 2013 at 10:29 AM, Mike Gouldthorp < [email protected]> wrote: > This query should give you the content location along with some other > useful information pertaining to your applications…**** > > ** ** > > SELECT [CI_ID] **** > > ,[CI_UniqueID] **** > > ,[SDMPackageDigest] **** > > ,SDMPackageDigest.value('declare namespace p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest";; > **** > > (p1:AppMgmtDigest/p1:DeploymentType/p1:Title)[1]', 'nvarchar(max)') > AS DTTitle **** > > ,SDMPackageDigest.value('declare namespace p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest";; > **** > > (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/@Technology)[1]', > 'nvarchar(max)') AS DTTechnology **** > > ,SDMPackageDigest.value('declare namespace p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest";; > **** > > > > (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:Contents/p1:Content/p1:Location)[1]' > , 'nvarchar(max)') AS DTContentLocation **** > > ,SDMPackageDigest.value('declare namespace p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest";; > **** > > > > (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:InstallAction/p1:Args/p1:Arg)[1]' > , 'nvarchar(MAX)') AS Install**** > > ,SDMPackageDigest.value('declare namespace p1=" > http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest";; > **** > > > > (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:UninstallAction/p1:Args/p1:Arg)[1]' > , 'nvarchar(MAX)') AS Uninstall**** > > FROM v_ConfigurationItems**** > > WHERE CIType_ID = 21 **** > > ** ** > > ** ** > > Thanks,**** > > Mike**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Marcum, John > *Sent:* Friday, May 31, 2013 10:22 AM > *To:* [email protected] > *Subject:* RE: [mssms] SQL for Application Source Path**** > > ** ** > > I need anything that has a source, but mainly msi and script based. I see > them in V_Package but the source is not listed there.**** > > **** > > Seems like there should be a v_Application but there’s not L**** > > **** > > **** > > **** > > **** > > **** > > **** > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Stephen Leuthold > *Sent:* Friday, May 31, 2013 10:17 AM > *To:* [email protected] > *Subject:* RE: [mssms] SQL for Application Source Path**** > > **** > > Deployment types? Todd Hemsell had the same question and I answered it a > week or so ago.. Let me see if I can dig it up. > > Sent from my Windows Phone**** > ------------------------------ > > *From: *Marcum, John <[email protected]> > *Sent: *5/31/2013 9:52 AM > *To: *SMS List ([email protected]) <[email protected]> > *Subject: *[mssms] SQL for Application Source Path**** > > Does anyone happen to know where in SQL I can find the source path of all > my applications?**** > > **** > > **** > > **** > > John**** > > **** > > **** > > **** > > **** > > **** > ------------------------------ > > > 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.**** > > ** ** > ------------------------------ > > > 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.**** > > ** ** > >
