Hi have to generate a report of assets based on their Windows update statue, but I also need to put in the report group their group membership for "some groups" only... but also need to find some other machine that they are not members of these groups. In fact, the group membership should not be a filter (where), but I just need to show some groups I use. Something like that:
| Asset | Patch Status | Domain | IsMemberOfSomeWUGroups | Lasttried... |
| PC1 | Up To Date | mydomain.com | WU group - monday | |
| PC2 | Up To Date | mydomain2.com | (null) | |
| PC3 | Out of Date | (empty) ** Workgroup ** | *** no group, not in an AD *** | |
I tried some way, but the command goes in error or consume CPU at 100% (impossible to resolve)
Basically, it's the same report that Lansweeper team share every months for Windows Update plus a personnalized touch to follow our ring deployment based on groups membership... But some machines that are in WORKGROUP or those on the "regular" ring are just not in a group (default).
The request I tested where is near of my goal generate multiple lines for all asset, one per existing groups associated on the asset... not what I need.
