NAC Database Query

Question

Hi,

In NAC (simple) we have three Policy groups namely Default, Managed and Unmanaged. I need to find the Clients assigned to a particular Policy.

Anybody knows SQL query?

I thank you in advance for any assistance.

Regards
FK

This thread was automatically locked due to age.

QC · Accepted Answer

Hello FK, policies are assigned to groups - so you better work with them and not individual computers. Anyway, this q&d query might help: SELECT p.Name AS NACPolicy,
 n.Name AS Computername
 FROM AliveComputers AS n 
 INNER JOIN ComputerPolicyMapping AS m ON m.ComputerID = n.ID
 INNER JOIN Policies AS p ON p.ID = m.PolicyID WHERE p.Type = 8 
 ORDER BY NACPolicy, Computername Christian :34785