topic Re: Hos to get full list of users & their belonging groups ? in Alfresco Archive

Hos to get full list of users & their belonging groups ?

msevestre — Wed, 05 Aug 2009 14:30:05 GMT

HelloI'm trying to generate a file with a JS script to help me to administrate users & group: I'd like to obtain a list with full clear test of user names & groups which they are attaached to ?I tried to create a Javascript script that is nearly working, but I am not able to display "readabl

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Wed, 05 Aug 2009 14:58:55 GMT

Try that one


var gens = people.getPeople(null);

var logFile = space.childByNamePath("log_users.txt");
if (logFile == null) {
   logFile = space.createFile("log_users.txt");
}
logFile.content = "";

for (var i=0; i<gens.length;i++) {
  logFile.content += gens[i].userName +"\n";

  var groupes= people.getContainerGroups(utils.getNodeFromString(gens[i]));

  for (var j=0; j<groupes.length;j++) {
    var groupName = groupes[j].properties["authorityDisplayName"];
    logFile.content += "\t"+ groupName +"\n";
  }

}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Hos to get full list of users & their belonging groups ?

msevestre — Wed, 05 Aug 2009 15:02:30 GMT

Hi !

No luck, the log file have the followiong result:

undefined
   null
   null
   null
undefined
undefined
undefined
   null
   null
   null
undefined
   null
   null
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Matt

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Wed, 05 Aug 2009 15:42:48 GMT

Again,


    var gens = people.getPeople(null);

    var logFile = space.childByNamePath("log_users.txt");
    if (logFile == null) {
       logFile = space.createFile("log_users.txt");
    }
    logFile.content = "";

    for (var i=0; i<gens.length;i++) {
      logFile.content += gens[i].properties["cm:userName"] +"\n";

      var groupes= people.getContainerGroups(utils.getNodeFromString(gens[i]));

      for (var j=0; j<groupes.length;j++) {
        var groupName = groupes[j].properties["cm:authorityDisplayName"];
        logFile.content += "\t"+ groupName +"\n";
      }

    }

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Hos to get full list of users & their belonging groups ?

msevestre — Thu, 06 Aug 2009 06:57:05 GMT

Hi….

still not working:

Failed to execute script 'workspace://SpacesStore/95602fd0-2b70-4929-a0ae-de0066726a60': TypeError: Cannot read property "cm:userName" from undefined (AlfrescoScript#10)

If i comment line #10, then the script is executed but I only have "null" disaplyed on each line of the log file…

Perhaps there's another way to do this ? (maybe the base of my script is not a good idea)

Matt

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Thu, 06 Aug 2009 07:13:57 GMT

What if you change this line :


var gens = people.getPeople(null);
‍‍‍


var gens = search.luceneSearch("TYPE:{http://www.alfresco.org/model/content/1.0}person");
‍‍‍

Re: Hos to get full list of users & their belonging groups ?

msevestre — Thu, 06 Aug 2009 07:15:41 GMT

Hi !

Then I get this error:

Failed to execute script 'workspace://SpacesStore/95602fd0-2b70-4929-a0ae-de0066726a60': Failed to execute search: TYPE:{http://www.alfresco.org/model/content/1.0}person

Matt

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Thu, 06 Aug 2009 07:58:53 GMT

All right, here it is (I had to test it on my environment to be sure)


    //var gens = people.getPeople(null);

var gens = search.luceneSearch("TYPE:\"{http://www.alfresco.org/model/content/1.0}person\"");
    var logFile = space.childByNamePath("log_users.csv");
    if (logFile == null) {
       logFile = space.createFile("log_users.csv");
    }
    logFile.content = "";

    for (var i=0; i<gens.length;i++) {
      logFile.content += gens[i].properties["cm:userName"]+"\n";

      var groupes= people.getContainerGroups(gens[i]);

      for (var j=0; j<groupes.length;j++) {
        logFile.content += "\t"+groupes[j].properties["usr:authorityDisplayName"]+"\n";
      }

    }

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope this will be valuable to you 😄

Re: Hos to get full list of users & their belonging groups ?

msevestre — Thu, 06 Aug 2009 08:08:33 GMT

Hi !

Well… username are now correctly displayed (thanks :mrgreen: !)… but I still get "null" as groups names… :?

Matt

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Thu, 06 Aug 2009 08:10:43 GMT

this is due to the way you built your groups.
Then replace usr:authorityDisplayName by usr:authorityName

Re: Hos to get full list of users & their belonging groups ?

msevestre — Thu, 06 Aug 2009 08:18:40 GMT

Hi !

Perfect, it works !

Note: me groups were created through the web interface and some other through javascripts scripts.

Thansk for your help !

Matt

Re: Hos to get full list of users & their belonging groups ?

jayjayecl — Thu, 06 Aug 2009 08:22:00 GMT

No problem, glad this helped

Re: Hos to get full list of users & their belonging groups ?

chandu7ee — Mon, 08 Mar 2010 13:36:17 GMT

hey thanks its worked fine..

but here i need to display the tenant names and users under these tenats..

is there any way to do this.

i did not found any tenants API in alfresco wiki.

thanks & regards
Chandu

Re: Hos to get full list of users & their belonging groups ?

jenn_l — Thu, 18 Mar 2010 20:36:37 GMT

Hi all,

I have an Alfresco 3.2r enterprise and Community 3.2r environment. The code above worked for Alfresco 3.0 and Alfresco 3.1.
In 3.2 I get null instead of all the defined groupnames with GROUP_ as a prefix.
Is there someone out there who can help me with retrieving the same as above mentioned in Alfresco 3.2?

Thanks,
Regards,
Jenny

Re: Hos to get full list of users & their belonging groups ?

kyriakos — Fri, 19 Mar 2010 12:08:54 GMT

sorry i want to do the same thing on community edition 3.2r
and also i wanted to know where the results are announced…
because i made a script and i called it but i get this warn

13:50:48,462 WARN  [org.alfresco.repo.cache.TransactionalCache.org.alfresco.userToAuthorityTransactionalCache] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).‍

Re: Hos to get full list of users & their belonging groups ?

majicj — Fri, 26 Mar 2010 18:39:12 GMT

sorry i want to do the same thing on community edition 3.2r
and also i wanted to know where the results are announced…
because i made a script and i called it but i get this warn
13:50:48,462 WARN  [org.alfresco.repo.cache.TransactionalCache.org.alfresco.userToAuthorityTransactionalCache] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).‍

I Encountered this error when running Alfresco in Windows. To fix this I had to edit my cache settings in tomcat\webapps\alfresco\WEB-INF\classes\alfresco\cache-context.xml file. I suggest making a backup copy of this file before editing in case you mess something up. I just increased the value (in your case try setting userToAuthorityTransactionalCache to 200 or 400 etc .) until the error went away.

Re: Hos to get full list of users & their belonging groups ?

kyriakos — Mon, 29 Mar 2010 06:48:26 GMT

thank you man

Re: Hos to get full list of users & their belonging groups ?

ilazki — Thu, 01 Apr 2010 08:41:43 GMT

To get the groups in the community edition (I'm using 3.2 r2) use cm:authorityDisplayName to get the group name without the GROUP_ prefix.
You can check the contentModel.

Hope it's usefull