yeah, and now I just noticed I have two "Inprogress" that's what happens when you quickly copy and paste! the one after 'Already Present' should really be 'Success'
Sherry Kissinger Microsoft MVP - ConfigMgr [email protected] ________________________________ From: Todd Hemsell <[email protected]> To: [email protected] Sent: Wednesday, April 16, 2014 4:33 PM Subject: Re: [mssms] Application Deployment reports nice! On Wed, Apr 16, 2014 at 4:26 PM, Sherry Kissinger <[email protected]> wrote: > 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 > [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. > > > >
