Does anyone know how to get a full list of all users from LSF9? Not all of our users are in laua. In fact most are not. We have approx 3500 users. I can get ssoconfig to give me 300, I can get jexplorer to give me 500, and I tried writing a report in the new Lawson Security, but it keeps failing.
Any help would be appreciated
You can create an RM Query in ProcessFlow and load it in a table. If you don't have PF Integrator, you can paint a program and use that program to add the records to the table (Transaction call) for each RM query.
You also might want to look at the lawrm.MaxQueryResult in your $LAWDIR/system/RMApiInit.properties file, you can set it to higher values or you can split your RM query in PF in batches.
Arvin Ojales
There's an alternate route, which we use. We run an LDAP tool like LdapAdmin or JXplorer, and dump various "branches" of the LDAP "tree" into an industry-standard LDIF file. Then we use various scripts to produce the reports that we need.
With over 500 users, I can dump out various LDIFs and have a complete report in a half-hour. There are a number of manual steps, of course.
My script takes LDIF output and turns it into various "flat" CSV files One interesting quirk of LSA is that the Identities are stored "backward" in the LDIF branches. One entry per Identity, with possible multiple RMID's. Since the RMID is a critical key when you look at "Resources" (Lawson's designation for People) this backwards construction was a problem, which my method requires working out via an Excel lookup.
(It's also possible to have things screwed up, with 2 Identity entries pointing to the same RMID; I've seen it.)
If my method is something you might want to look at, I can send you a copy of my Excel spreadsheet. The spreadsheet is basically empty; it is simply a container to hold the VBA code that I wrote. If you're interested, email me: mtsukroff at-sign edisonschools dot com
What version of Lawson are you using? Also are you using UNIX or Windows?
Both ADAM and Tivoli ND come with a utility called 'ldapsearch' - with it you can extract anything