View Policies received timestamp from Console

Discussion in 'Parallels Mac Management for Microsoft SCCM' started by RobR1, Oct 17, 2016.

  1. RobR1

    RobR1 Bit Poster

    Messages:
    4
    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
     
  2. RobertM18

    RobertM18 Bit Poster

    Messages:
    4
    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'
     

Share This Page