Shane Corellian
posted this on February 22, 2010 17:40
From your Admin Arsenal main window select the "New Report..." command from the Reports Menu.
In the top field (this is your query field) paste the following data:
SELECT c.Name, lgm.GroupName, lgm.UserDomain, lgm.UserName
FROM Computer c
INNER JOIN LocalGroupMember lgm on c.computerid = lgm.computerId
WHERE lgm.GroupName = 'Administrators'
Hit the Refresh button and you should be returned with a report that shows the Computer, Group Name, UserDomain and UserName of each account that is in the local Administrators group.
The custom report builder allows you to access all the data that Admin Arsenal collects and report it in a way that fits your purpose.
http://www.adminarsenal.com/admin-arsenal-blog/bid/26707/Computer-I...