local groups discovery

[AZHockeyNut]

we had an application that is no longer in use. during its install it created 2 local groups. Naturally those are no longer needed, however, the uninstall process did not remove those groups. Is there a way I can report on each system that has those groups and then automate their removal?
I assume the SIDS will be unique per pc, so I am probably left with exact name matches? looking to not have to go to each system and clean them up.

[Bruce_B · Accepted solution]

You could delete these groups en masse using a report and a deployment package that runs against this report.

The command used in the deployment module should be the following:

net localgroup <GroupName> /delete

Modify the report below with the correct group names:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblGroupUni.Name As GroupName,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblGroups On tblAssets.AssetID = tblGroups.AssetID
Inner Join tblGroupUni On tblGroupUni.GroupID = tblGroups.GroupID
Where (tblGroupUni.Name = 'group1' Or tblGroupUni.Name = 'group2') And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName