Custom Group Report
Hi All, ive been trying to configure a report to filter on groups beginning with a specific name and having the members listed with the following attributes:
Not sure why but ER 2.5.1 doesn't allow for that level of granularity. Can anyone help a beginner with ER.
Thank you for your inquiry. We are reviewing your request and will follow up tomorrow.
I found this existing custom query report that might serve as a good starting point.
You can download the ZIP file, unzip it, and import the XRD file into Report Manager under the My Reports folder. Just let me know if you need more detailed instructions.
Once you run this report, you can let me know if it will meet your needs or if we can assist with further edits.
Thank you,Valerie :)
this report doesn't really help. What im trying to get is a report on all groups beginning with certain names, eg:
and then to list out all members of those groups with the following attributes:
ER doesn't appear to allow for this level of granular reporting (or not that I can find).
I have modified the Domain Groups with Members report for you here:
To create this report, here are the general steps that I used:
PLEASE NOTE: in the parameters, you may specify groups beginning with certain names by entering wildcards (as you have indicated); however, if the group name includes the domain name, you may need to include a preceding asterisk to get the results you are looking for (e.g. *SL_* ). You can add more than one of these at a time and then run the report to include them all.
Happy to answer any questions,Kind Regards,Val :)
this is perfect, many thanks.
I have just one more question on this. Im also using an underscore in my groups search, eg:
But ER doesn't appear to see or under stand the "_"entry. Is this a bug or do you know a way around this?
Yes, it is necessary to wrap the underscores in square brackets.
Try CUST[_]* and let me know how it goes!