DesktopCentral, Members of Custom Groups
Hi,
I'd like to have a report about the members of the custom groups. Someone posted a custom query for a report of computers within no group. That query works fine. Is it possible to change it to show all groups with all members? Here's the report for Computers in no group: select Resource.NAME from Resource
I'd like to have a report about the members of the custom groups. Someone posted a custom query for a report of computers within no group. That query works fine. Is it possible to change it to show all groups with all members? Here's the report for Computers in no group: select Resource.NAME from Resource
inner join ManagedComputer on (Resource.RESOURCE_ID = ManagedComputer.RESOURCE_ID)thanks in advance
left join CustomGroupMemberRel on (CustomGroupMemberRel.MEMBER_RESOURCE_ID = ManagedComputer.RESOURCE_ID)
where CustomGroupMemberRel.MEMBER_RESOURCE_ID is null
order by Resource.NAME
Topic Participants
Ratthey Michael
Saranraj Kumar
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?