You are viewing limited content. For full access, please sign in.

Question

Question

Installing sql.lite on the licence server

asked on August 22, 2019 Show version history

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!

0 0

Replies

replied on August 27, 2019

I don't see why that wouldn't work. Though, you should consider that this would allow users to remote into the server and run PowerShell scripts. So you may want to secure the server further with the appropriate PowerShell execution policy.

In the longer term, you should consider upgrading to Laserfiche 10 and Directory Server so you can use Microsoft SQL Server tools.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.