Is it possible to find when SCCM ran a deployment against a specific client PC, from the server? (CAS, primary or even secondary will do so long as I can script through to the data starting with only the PC name)
This is an SCCM2012R2 environment.
I have found the WMI class SMS_AppDeploymentAssetDetails, however the time returned is the time the deployment was associated with the collection. For example, on a machine task-sequenced only a few days ago:
AppName : A Name CollectionID : 101010 CollectionName : OS-All Windows 7 Workstations DTCI : Numbers (deployment type ID - maybe there is a GUID for a specific deployment instance somehwere?) DTModelID : Numbers DTName : A softwares - Windows Installer (*.msi file) MachineName : CoolComp StartTime : 20140609040200.000000+*** StatusType : 1
Note the 2014 start time.
Same issue on the backend database table vAppDeploymentAssetData.
This does at least seem to indicate whether deployment on that specific machine was successful (there is an entry on this table for every single deployment event, per-workstation)
So if anyone aware of a way to do find this time (so it would look something like this:
DTCI : Numbers InstallTime : 20160708040200.000000+*** MachineName : CoolComp
) with WQL or SQL (or, some other method, maybe SCCM powershell cmdlets?)