Maybe try it with a like? I have seen some WMI queries that don't work with equals but work fine with like. You just increase processing time a bit.
Select * from ccm_application where evaluationstate like '%12%' Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Friday, June 28, 2013 6:04 AM To: [email protected] Subject: RE: [mssms] SOLVED: CM12: Currently running application installation, Client Center In case you're interessted: The value to look for is 12 Application is currently enforcing. I was thinking to just do this to get the one current installation running: Select * from ccm_application where evaluationstate = 12 Well, that doesn't work, telling me that this query is not supported. So, I had to workaround: Select * from ccm_application where evaluationstate != 1 I've chosen 1 so I get most entries already excluded in my case. And then I check all the result if one has 12 in a for each That works, just weird that I can't do "= 12" directly -R From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Ryan Sent: Dienstag, 25. Juni 2013 17:42 To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] CM12: Currently running application installation, Client Center Evaluation state is what you want... I ran a log installing 100+ apps and I watched evaluation state (among other things). Evaluation state 12 seems to correspond to "Installing". Check out this article to see what those values mean according to Microsoft: http://msdn.microsoft.com/en-us/library/jj874280.aspx Evaluation State Value Description 0 No state information is available. 1 Application is enforced to desired/resolved state. 2 Application is not required on the client. 3 Application is available for enforcement (install or uninstall based on resolved state). Content may/may not have been downloaded. 4 Application last failed to enforce (install/uninstall). 5 Application is currently waiting for content download to complete. 6 Application is currently waiting for content download to complete. 7 Application is currently waiting for its dependencies to download. 8 Application is currently waiting for a service (maintenance) window. 9 Application is currently waiting for a previously pending reboot. 10 Application is currently waiting for serialized enforcement. 11 Application is currently enforcing dependencies. 12 Application is currently enforcing. 13 Application install/uninstall enforced and soft reboot is pending. 14 Application installed/uninstalled and hard reboot is pending. 15 Update is available but pending installation. 16 Application failed to evaluate. 17 Application is currently waiting for an active user session to enforce. 18 Application is currently waiting for all users to logoff. 19 Application is currently waiting for a user logon. 20 Application in progress, waiting for retry. 21 Application is waiting for presentation mode to be switched off. 22 Application is pre-downloading content (downloading outside of install job). 23 Application is pre-downloading dependent content (downloading outside of install job). 24 Application download failed (downloading during install job). 25 Application pre-downloading failed (downloading outside of install job). 26 Download success (downloading during install job). 27 Post-enforce evaluation. 28 Waiting for network connectivity. On Tue, Jun 25, 2013 at 10:34 AM, Roland Janus <[email protected]<mailto:[email protected]>> wrote: Thanks Roger. I saw those in the queries for the CM12 version. Very useful btw, but I was asking what query would return the currently installing application (my question sucked), not the status of all the apps but the one saying "Installing" in Software Center. Like with CCM_ExecutionRequestEx for the current installing program. I want to return the data for that single currently running entry: Application name, deploymenttype name etc. -R From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Roger Zander Sent: Dienstag, 25. Juni 2013 13:44 To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] CM12: Currently running application installation, Client Center The main Page for CM12 related Client Center questions is on: http://sccmclictr.codeplex.com where you can use/link your LiveID Account ... For the Application Model, all needed information is in the Class CCM_Application: get-wmiobject -query "SELECT * FROM CCM_Application" -namespace "ROOT\ccm\ClientSDK" http://msdn.microsoft.com/en-us/library/jj874280.aspx The Property "EvaluationState" and "InstallState" will show you the current status of an Application... To get an adhoc List of all pending Application, i would run something like: get-wmiobject -query "SELECT * FROM CCM_Application" -namespace "ROOT\ccm\ClientSDK" | where {$_.EvaluationState -gt 5 } For SoftwareUpdates, the corresponding Class is CCM_SoftwareUpdate http://msdn.microsoft.com/en-us/library/jj155451.aspx The CCM_ExecutionRequestEx Class does still exists, so I assume it's for the legacy package Model... Regards Roger ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] CM12: Currently running application installation, Client Center Date: Tue, 25 Jun 2013 12:45:06 +0200 A possibility, but then I need (another) account for that. Hoping Roger chimes in as last time :) -R From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Craig Andrew (OIZ) Sent: Dienstag, 25. Juni 2013 11:11 To: [email protected]<mailto:[email protected]> Subject: AW: [mssms] CM12: Currently running application installation, Client Center perhaps try the discussions link on sourceforge? http://sourceforge.net/p/smsclictr/discussion/ Von: [email protected]<mailto:[email protected]> [mailto:[email protected]] Im Auftrag von Roland Janus Gesendet: Dienstag, 25. Juni 2013 10:58 An: [email protected]<mailto:[email protected]> Betreff: [mssms] CM12: Currently running application installation, Client Center I was using root\ccm\SoftMgmtAgent and a query like this "select * from ccm_executionrequestex where runningstate = 'running'" for CM07 to retrieve the currently running program installation. Thanks to Roger for that as it is in Client Center for CM07. Now I'm looking for the equivalent on CM12 for applications. Any pointers? Roger? :) -Roland The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
