Discussion Forums/PDQ Inventory/Inventory - Questions

Answered

Create collection to find group members

Jprater
asked this on October 19, 2011 13:40

I'm using 1.0 release 1 in Pro mode. We would like to create a collection that would list all the machines with certain users in the local administrators group. I opened an inventoried computer and saw it collects the local groups and users, but when I tried to create collection and add a filter, I couldn't find a filter that would filter the local groups/users. Is this possible? Thanks!

 

Comments

User photo
Shane Corellian
Admin Arsenal
Ajax_loader_small Answer

Since you are running in Pro Mode, you can create a Report to show the info you seek. We have plans to add the ability to use Local Group membership in collection criteria.

To illustrate: I created a report to show all the members of the Administrators group on the computer, Quagmire. I also filtered out local accounts from being displayed.

invReport-LocalGroupMembership1.png

 

Here are the filters that I used to narrow the returned data:

invReport-LocalGroupMembership2.png

 

Here is the returned data

invReport-LocalGroupMembership3.png

 

We are hoping to have these same filters available for Collections in the next release.

October 19, 2011 14:38
User photo
Jprater

Now is it possible to show only computers that don't match certain criteria? For example, all of our workstations should only have three users/groups in the local administrators group: Administrator, Domain Admins, and MIS. I'd like to generate a report that will show me all the workstations where the local administrators group differs from this. Thanks!

October 20, 2011 07:04
User photo
Adam Ruth
Admin Arsenal
Ajax_loader_small Answer

Yes, you can use the "does not match expression" filter type:

Local Group Name equals Administrators
Local Group Member Name does not match expression Administrator|Domain Admins|MIS

That'll give you every user in the Administrators group that isn't one of the three values. 

October 20, 2011 13:36