We ran into an issue where we were way over in our # of named licenses being used vs. what we paid for. Consequently, we are doing a lot of clean up and inactivation of RQC users that no longer need or use RQC.
I'm looking for a way to run a query of active users in RQ04 (REQUESTER) and join that up with their identities, roles, classes in Lawson Security. I'm told there is no way to query the security data in Lawson V10.
The only way I can think of right now is running LSA reports, dump output to a CSV file, and then dump the CSV file into a custom table and use that table to join up to the REQUESTER table based on ID and do the reporting that way. I'm told there is no way to automate the creation of the reports out of LSA either - so that would still need to be manual to create the CSV files.
We want a way to report users that have an active record in RQ04 but don't have all the appropriate access in LS (such as not having PROD_REQUESTER) and we also want to do the reverse (have PROD_REQUESTER) but do not have an active record in RQ04. We also want to report on users that have an active RQ04 record but do not have SSOP in LS.
Those are just a couple of examples. Has anybody come up with a way to do something like this?
