report of computers with their organizational group
Here in our company, we use an automation policy to assign the computers to certain organizational groups, based on theit IP-adress
Now i tried to make a report where i can see an overview of the computers, some basic hardware info and the organizational group they're in.
i already found some info in this post (https://www-secure.symantec.com/connect/forums/sql-query-organizational-group), but this only works with the GUID's of the groups.
with this post I found that in the table "ScopeMembership" you can find the guid of the group, but i can't figure our where the actual name is stored
i searched through the tables in the database, but without succes.