since app deployments are state message based, you have to think of them that way. I just quickly made this up... no idea if the results returned will get you want you want or not. But it's a start. The main parameter is the assignmentID. selectdistinct s1.netbios_name0, ae.AssignmentID, ae.descript, ae.EnforcementState, ci2.LastComplianceMessageTime, ae.AppEnforcementState, casewhenae.EnforcementState =1001 then'Already Present' whenae.EnforcementState >1000 Andae.EnforcementState <2000 Andae.EnforcementState <>1001 then'InProgress' whenae.EnforcementState >2000 Andae.EnforcementState <3000 then'InProgress' whenae.EnforcementState >3000 Andae.EnforcementState <4000 then'RequirementsNotMet' whenae.EnforcementState >4000 Andae.EnforcementState <5000 then'Unknown' whenae.EnforcementState >5000 Andae.EnforcementState <6000 then'Error' Endas'State' fromv_R_System_Valid s1 joinvAppDTDeploymentResultsPerClient ae onae.ResourceID=s1.ResourceID joinv_CICurrentComplianceStatus ci2 onci2.CI_ID=ae.CI_ID ANDci2.ResourceID=s1.ResourceID whereae.AssignmentID =@assignmentID andae.EnforcementState isnotnull
Sherry Kissinger Microsoft MVP - ConfigMgr [email protected] ________________________________ From: "Beardsley, James" <[email protected]> To: "[email protected]" <[email protected]> Sent: Wednesday, April 16, 2014 3:38 PM Subject: [mssms] Application Deployment reports What’s the best way to view detailed statistics on the status of a specific deployment broken down by success/failure/waiting/etc? I see reports for viewing the status of package deployments but not an application deployment. I need to get more information than what the Deployment Monitoring node provides. I’m having a hard time finding something as simple as what time the specific application was run (like the Last Status in the CM07 reports). I see where I can add the “Deployment Time” column to the monitoring node but that is what time it is scheduled for, not when it ran. I sure do miss the ability in CM07 where you can right click on an advertisement and directly open to the report to check the status of it. Hopefully something like that is in the CM12 console and I’m just not seeing it. Thanks, James ________________________________ IRS Compliance: Any tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties imposed under the Internal Revenue Code or applicable state or local tax law or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein. ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
