List of users from IB - 1C?

Question

1C

I am an administrator in a small organization that uses 1C, but I myself do not work directly with 1C (only adding users, creating new IBs, etc.). Number of bases - 500+.
The task is to somehow go through each IB and extract the list of users of each IB (in order to delete old employees and other accounts). Ideally, this should be done using PowerShell, as far as I know, you can interact with 1C using COM, but I didn’t find clear instructions (I would be grateful if someone poke their nose into the guide).

Answer 1

then this is it:
https://infostart.ru/public/1093370/
https://infostart.ru/public/629834/ - you should pay attention to this, there is a set of different programs to simplify the work.

Ideally, this can be done using PowerShell,

difficulties may arise, because in 1s, you need to add not only a user, but assign him the appropriate roles, access rights. And in new systems, this is not trivial, if the code is to create a set of related directories and information registers.

Answer 2

Use GetDatabaseStorageStructure to find the table you need in MS SQL and read the data directly.

Answer 3

Number of bases - 500+.

If the configurations are on managed forms, then with such a number of bases, I advise you to look at the 1CFRESH technology. Among other things, the technology allows you to use a common list of users for all databases. For each user, you can specify a list of databases to which he will have access and rights. All the databases to which the user will be granted access, he will be able to enter with a single login and password, which, again, with one click can be canceled or changed at once for all IBs, change the list of available databases, etc. In general, the 1CFRESH admin panel is excellent.
+ the technology has many other nice features, for example, if the configurations are typical, then you can update all information security at once in one fell swoop, there is a ready-made Service Desk that is built directly into typical 1C configurations and many others.