By running this query can source path, Inastall and Uninstall command being showed from a SQL query:

 

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