Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 1109 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

NAC Database Query

FK

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

:34783


This thread was automatically locked due to age.
Parents
  • 0

    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
Reply
  • 0

    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
Children
No Data