View Policies received timestamp from Console

R

RobR1

Bit poster
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'
 
You must log in or register to reply here.
Back
Top