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.
