How to list all the local administators over our domain?

Contact Home

IDEAL
Administration

IDEAL
Dispatch

IDEAL
Remote

IDEAL
Migration

FAQ : IDEAL Administration

Simplified management of Windows Active Directory domains and Workgroups from a single console

Search	FAQ: Help By using this search engine, you can search one or more terms in the complete Pointdev FAQ. In order to look for one or more keywords, type them in the search field using space to separate them. ex : remote control This search will show you every FAQ containing the word "remote" OR "control". In order to look for a full sentence, use the quotes " " around your keywords ex : "remote control" This search will show you every FAQ containing the whole word "remote control".

Title and Content Title only

How to manage database inventories of Windows Active Directory Domain?

Il would like to list and find out if there exist, all the users who are member of the local administrator group on all workstations of our domain.

Is it possible and how may I proceed ?

Yes, it can be done with IDEAL Administration.

You can use the "DataBase Exporter" tool (from the "Inventory" menu). Select "User groups" object and select the target computers of your domain by clicking "Select" button.

Then launch the inventory by clicking "Execute". Once the process is done, you can view the inventory by clicking on "Viewer MDB".

Search for "Administrators" in the "Group_name" column and for "Local" in the "Group_Type" column. Members are stored in the "Member" column.

You can easily create a SQL request in order to filter these lines.

If you want to export into an SQL Server Database, do not forget to open the "Tools" menu, then "Options", "Database" and to check/configure "SQL Server database" ("MS Access database" by default).

Also read: How to extract information from database inventories?

Last modification: 04/06/2023

Back to the list

IDEAL Administration

Simplified management of Windows Active Directory domains and Workgroups from a single console

IDEAL Administration simplifies the administration of your Windows Workgroups and Active Directory domains by providing in a single tool all the necessary features to manage domains, servers, stations and users.

It performs all the administration tasks like Active Directory management and reporting, remote control operation for Windows, Mac OS X and Linux, Active Directory & file server migration, hardware and software inventories.

> Learn more...

Starts at $ 329 (USD)
See Full Price List

FAQ : IDEAL Administration | IDEAL Dispatch | IDEAL Remote | IDEAL Migration