Video Screencast Help

report of computers with their organizational group

Created: 21 Feb 2011 • Updated: 22 Feb 2011 | 2 comments
This issue has been solved. See solution.

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.

any ideas?

Comments 2 CommentsJump to latest comment

mclemson's picture

The item table has the name.  I've posted some thoughts for a different user in this thread:

https://www-secure.symantec.com/connect/forums/i-need-create-two-more-colums-using-attached-sql-query-am-stuck

So if you have the GUID of the group, you join that to the Item table based on the SecurityGuid column:

JOIN Item ON ScopeMembership.ScopeCollectionGuid=Item.SecurityGuid

Select 'Item.Name' as the name of the group and 'Item.Description' as the description of the group.

Keep in mind that your query must have already narrowed it down to a single group.  A computer can exist in multiple views, with one group in each view.  Either that or be prepared for multiple groups.  The name of the group is just the last object.  So if your group names are not unique (e.g. Chicago\Workstations, Chicago\Servers, Boston\Workstations, Boston\Servers), you'll be confused since you only see the final level (e.g. a report would show Workstations or Servers, but not Chicago\Workstations or Boston\Servers, etc).

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION