Hi,

I would like to get a WQL query which reports the clients with last specified numbers of days since the last policy request

Also with their OS,AD site, Machine Type (laptop or desktop)

I searched but all came up with last hardware and software inventory but could not find this.

Thanks

Please assist

Hello,

As far as I know, there is a client log PolicyAgentProvider.logwhich may help us find out the information. However, you will need script to collect all the logs over your site.

I'm not near a lab right now, but I believe that info is in the db, at least the last 'successful' policy request. If you need to find unsuccessful policy requests, that may be a different story.  If you can wait a few days until I'm back at my lab, I'll see if I can find that.

The last policy value is in v_CH_ClientSummary.

Here's a basic from query, adjust it to your need.

SELECT v_CH_ClientSummary.MachineID, v_CH_ClientSummary.NetBiosName,
  v_CH_ClientSummary.LastStatusMessage, v_CH_ClientSummary.LastPolicyRequest,
  v_CH_ClientSummary.LastSuccessfulPing, v_ClientHealthState.HealthStateName
FROM v_CH_ClientSummary INNER JOIN v_ClientHealthState ON
  v_CH_ClientSummary.NetBiosName = v_ClientHealthState.NetBiosName
ORDER BY v_CH_ClientSummary.NetBiosName

Sherry, yes i would need the information when you are back.

Thanks Benoit, i believe thats SQL ? Would be great if i can get WQL.

Hey Sherry,

Any chance getting the required query as the concern has come up again :) 

Thanks