I need to create a report that my help desk can use to see the status of an
application deployment for a given app to a given user. It looks like the info
I am after is in this function but I'm not sure how to interpret it. Can
someone tell me what the values in these columns mean? Or better yet, has
anyone come up with a similar report already? Seem odd there's no out of the
box report for this
select
top 1
SMS_AppDeploymentAssetDetails.AppStatusType,
SMS_AppDeploymentAssetDetails.DTCI,
SMS_AppDeploymentAssetDetails.ComplianceState,
SMS_AppDeploymentAssetDetails.DeploymentIntent,
SMS_AppDeploymentAssetDetails.DTResultID,
SMS_AppDeploymentAssetDetails.EnforcementState,
SMS_AppDeploymentAssetDetails.InstalledState,
SMS_AppDeploymentAssetDetails.UpdateState
from fn_AppDeploymentAssetDetails(1033) AS SMS_AppDeploymentAssetDetails
________________________________
John Marcum
MCITP, MCTS, MCSA
Sr. Desktop Architect
Bradley Arant Boult Cummings LLP
________________________________
[H_Logo]
________________________________
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.
