Thanks Sherry. I’ll play around with this. Would this also work for user-based assignmentid’s? I’m getting results for my machine based deployments but not user. Is there another table for user?
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Wednesday, April 16, 2014 5:27 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] Application Deployment reports 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. select distinct s1.netbios_name0, ae.AssignmentID, ae.descript, ae.EnforcementState, ci2.LastComplianceMessageTime, ae.AppEnforcementState, case when ae.EnforcementState = 1001 then 'Already Present' when ae.EnforcementState > 1000 And ae.EnforcementState < 2000 And ae.EnforcementState <> 1001 then 'InProgress' when ae.EnforcementState > 2000 And ae.EnforcementState < 3000 then 'InProgress' when ae.EnforcementState > 3000 And ae.EnforcementState < 4000 then 'RequirementsNotMet' when ae.EnforcementState > 4000 And ae.EnforcementState < 5000 then 'Unknown' when ae.EnforcementState > 5000 And ae.EnforcementState < 6000 then 'Error' End as 'State' from v_R_System_Valid s1 join vAppDTDeploymentResultsPerClient ae on ae.ResourceID=s1.ResourceID join v_CICurrentComplianceStatus ci2 on ci2.CI_ID=ae.CI_ID AND ci2.ResourceID=s1.ResourceID where ae.AssignmentID = @assignmentID and ae.EnforcementState is not null Sherry Kissinger Microsoft MVP - ConfigMgr mofmas...@myitforum.com<mailto:mofmas...@myitforum.com> From: "Beardsley, James" <james.beards...@dhgllp.com<mailto:james.beards...@dhgllp.com>> To: "mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>" <mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>> 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. ________________________________ 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.