Hi there folks
I wonder if some kind soul would be able to guide me on something which I am
trying to develop please.
I have a SQL query:
SELECT fn_AppDeploymentAssetDetails_1.MachineName,
fn_AppDeploymentAssetDetails_1.CollectionName,
fn_AppDeploymentAssetDetails_1.AppName, fn_AppDeploymentAssetDetails_1.DTName,
fn_AppDeploymentAssetDetails_1.Technology,
fn_AppDeploymentAssetDetails_1.DeploymentIntent,
fn_AppDeploymentAssetDetails_1.StartTime,
fn_AppDeploymentAssetDetails_1.StatusType,
fn_AppDeploymentAssetDetails_1.AppStatusType,
fn_AppDeploymentAssetDetails_1.ComplianceState,
fn_AppDeploymentAssetDetails_1.EnforcementState,
fn_AppDeploymentAssetDetails_1.DTResultID,
fn_AppDeploymentAssetDetails_1.InstalledState,
fn_ListDeploymentTypeCIs_1.SDMPackageDigest
FROM dbo.fn_AppDeploymentAssetDetails(1033) AS
fn_AppDeploymentAssetDetails_1 INNER JOIN
dbo.fn_ListDeploymentTypeCIs(1033) AS
fn_ListDeploymentTypeCIs_1 ON fn_AppDeploymentAssetDetails_1.DTCI =
fn_ListDeploymentTypeCIs_1.CI_ID
which shows all of the deployments that I have and then the systems and the
deployment type that was run.
The ask from the customer now is for the App-V applications to be able to also
show the icons published by this deployment type and the manifest file. The
idea then is to join this with discovery data so that we are able to show that
the package has streamed down and when the App-V application was last run on
this system.
Of course this would be great were the content not represented in XML held
within SQL so I wonder if someone can guide on parsing the XML to build some
rows please?
Thanks in advance
Jason
