How do I get a list of all MACs from all End-System Groups (GraphQL)?

[brs21]

I'm trying to pull a list of all MAC addresses for all End-System Groups within SiteEngine in order to compare them to our asset inventory.

I've tried using GraphQL to pull a list of all the MAC addresses using the following query:

    query AccessControl {
      accessControl {
        allEndSystemMacs
      }
    }

I do get a list of MACs with that query.  The problem is that this pulls all MAC addresses for anything that has attempted to connect to the NAC, not just the MACs under the End-System Groups - so my list is full of randomized MACs and MACs from rejected connection attempts.

I've looked at 'endSystemInGroups' but that will just return the Group information for a single entry.

Any ideas or is there a simpler method within the GUI that I am missing?

[Zdeněk_Pala]

Hi,

here is API call to get all your groups:

query{accessControl{allGroups {
  GetType
  description
  name
}}}

here is API call to get content of you group:

---

query{
  accessControl {
    group(name: "Blacklist") {
      values
    }
  }
}

Hope it helps.