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.
>
>
>
>
