Request a custom report that will combine reports of "Domain Groups and Members" and "Domain Computer with Member Of Information" to show the members I have in three groups and which computers those groups are on. Can this be done?
Request a custom report that will combine reports of "Domain Groups and Members" and "Domain Computer with Member Of Information" to show the members I have in three groups and which computers those groups are on. Can this be done?
Hi,
Does this example look like what you want?
Domain Group1
Member1
Member2
------
Computer1
Computer1 Group
Domain Group1
Computer2
Computer2 Group
Domain Group1
Thanks,
Philip
I need the custom report in csv format.
I also want the computer groups to included with the Nested members as well and to be able to add a filter for the Domain Group names.
Hello,
Just for clarification,
I think you are looking for the list of all Computers whose computer groups contain any of the 'filtered'(3) Domain Groups,
and to show the recursive membership of those matching computer groups or show the recursive membership of the filtered groups?
Thanks,
Philip
Yes. I believe that is correct.
Do you want to show the recursive membership of the filtered groups or of the computer groups that contain the filtered groups?
If possible... both!
If possible... both!
Wondering about the status of this request?
Please find a custom report for your request at the link below
https://www.quest.com/community/enterprise-reporter/m/custom-reports/254
Thanks,
Philip
I know it is pulling in a lot of data for the report, however, I killed it after an hour of running. Here are the fields I need from both reports:
Domain Groups and Members:
Domain Name (Domain) | Canonical Name (Domain OU) | Account Name (Group) | Account Name (Member Account) | Display Name (Nested User) | Member Type (Member Account) | Last Collected Time (Domain) |
What Computers AD Group Is On:
Domain (Computer) | Computer Name (Computer) | Account Name (Group) | Account Name (Group Member) | Type of Account (Group Member) | Last Collected Time (Physical Computer) |
Is this possible?
An updated report is available at
https://www.quest.com/community/enterprise-reporter/m/custom-reports/255
Thanks,
Philip
This report will not allow me to either any groups in the field "Include domain groups to search for computer groups they belong to". I was able to fill this field in the first version you sent.
Report has been updated