The RemoteLink application has been a valuable tool in helping our customers automate day-to-day store operations reporting as well as data transfer and backend processing. Automating the operational data movement and processing only provides part of the solution. Providing an automated reporting process which consumes the data and provides it to systems administrators and management allowing organizations to have valuable insight into their operations.
RemoteRelief has working knowledge of the backend databases and has created a ‘utility’ that can be implemented with the RemoteLink sessions to generate a report for your overnight jobs.
The process is not a ‘one size fits all’ kind of thing and will vary from customer to customer. For example, there may be the need to see a job’s performance or the condition to see a specific time frame. It all depends upon the customer’s requirement. In order to accomplish this; you will need to have access to the SQL Server database from your RemoteLink application server. A RemoteLink session will need to be set up and configured to run the SQL Server script against the RemoteLink database. Generating a report only requires reading few tables so granting read access should be enough.
*The RemoteLink server must also have to have ability to run a PowerShell script.
RemoteRelief has SQL, SQL Database, and RemoteLink subject matter experts (SME), who aid clients in setting up and automating these types of processes. If you would like more information, subscribe to our tech blogs. If you are interested in a demonstration or learning more about operational data movement, RemoteLink features, automation and reporting capabilities click here to speak with an SQL SME.