vPackage
select PkgID, Name, Source from vPackage From: [email protected] [mailto:[email protected]] On Behalf Of Mike Gouldthorp Sent: Friday, May 31, 2013 11:30 AM To: [email protected] Subject: RE: [mssms] SQL for Application Source Path 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 ☹ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stephen Leuthold Sent: Friday, May 31, 2013 10:17 AM To: [email protected]<mailto:[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<mailto:[email protected]> Sent: 5/31/2013 9:52 AM To: SMS List ([email protected])<mailto:[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. ********************************************************** Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues
