Our customer's IT Security team have a need for monthly extracts of user data from various systems. For Laserfiche this has always required them to manually go into the admin console > Export > send .csv file to Security, meaning that Security cannot be self-sufficient (as they don’t have access to the console, and the actions are manual ones performed by our customer).
The LF_LM.db can be penetrated using SQL.lite, and our customer has written a Powershell tool for their team to use locally, but it requires that anyone running the automated extract has sql.lite installed locally.
Would there be any issue with installing sql.lite on the licence server itself, so that they could hand over the Powershell tool to their Security team for them to run whenever they require it, without the need to have sql.lite installed locally for every Security team user? If the sql tool is on the licence server then it will require only one instance to be called by the Powershell script, rather than a scattering across multiple user machines.
The customer is using product version 9.1.1.486 on Windows Server 2008 R2 Standard, SP1
Thanks!