When viewing the PMM client properties on a Mac Endpoint through System Preferences there are two fields with a timestamp for the value (3 actually, but I'm ignoring the Cert expiration date): Connected to SCCM Proxy and Policies received I would like to be able to run a report from SCCM showing these two values for a set of Mac's. Is this data available in the PMM/SCCM Database? If so, can you provide a path or SQL query that I can use to find and report on it? Thank you, Rob
select vrs.Name0, ch.LastDDR, ch.LastHW, ch.LastPolicyRequest from ch_clientsummary ch join v_r_system vrs on ch.MachineID = vrs.ResourceID where name0 = 'insertpcname'