Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Filter for report doesn't do the same for collection

Couldn't find anything similar so hopefully this isn't a duplicate.

We're having a weird issue with trying to create a dynamic collection based off a report.  The report seems to do what we want however when we do a dynamic collection based off that (Either by copying/pasting the filter or picking "New Collection from Report"), the results are way off.

What we're trying to do is create a collection\report for computers that have domain accounts, other than 2, that are in the "Administrators" group.

Our report filter, which seems to work as intended:

The same as the dynamic collection:

The numeric results:

That's a pretty big discrepancy.

An example computer:

Based on the filter, this computer shouldn't be included in the dynamic collection.  The report shows this:

I've tried many different combinations of the filter.  I can either get 0 or the full 161.  I never seem to get the in-between actual result I'm looking for.  If I'm doing something wrong, I'd love to hear it, but I'm also curious why it would work for a report but not a dynamic collection of machines. 

0

Comments

1 comment
Date Votes
  • Salesforce Cross Filters allow you to create a report that identifies records with or without a related record ex: football legends solve the problem for me

    -1