<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=134816313595691&amp;ev=PageView&amp;noscript=1">

RemoteRelief BLOG

Let's talk business technology...

All Posts
Reading Time: 2 minutes
 
Published on 3/4/20 5:27 PM

GENERATING THE JOBS RESULTS REPORT FROM THE REMOTELINK DATABASE

Introduction

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.

What Do We Need?

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.

How Do We Do This?

  1. A stored procedure will be created in the RemoteLink database to read and generate the data for the report.
  2. Another SQL Server script will be executed from the RemoteLink Server to execute the stored procedure for specific days.
  3. A PowerShell script will be created to run the SQL Script.
  4. A RemoteLink session will be required to execute the PowerShell script to generate the report in an HTML format (and email to specific user if needed).

Final Results

Generating the JOBs Results Report from the RemoteLink Database - finalresults

Need Help?

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.

 

Enjoy this article? Don't forget to share.

 
Neeraj Mehta
Author: Neeraj Mehta
Senior Database Consultant at RemoteRelief: Enthusiastic technology team player with sound business acumen of retail and point of sale processes. Plan, develop, and implement IT solutions using SQL Server to deliver best experience for end-users.

Related Posts

Database Administration for the Modern Age

We cant hide the fact that we are living in the middle of the internet explosion era, data has evolved to...
Bryan Afonso Reading Time: 2 minutes

Workspace IoT Endpoint Management

Remote Relief delivers secure Workspace IoT endpoint management at scale.  Internet of Things (IoT) techn...
Bryan Afonso Reading Time: 2 minutes

Simplifying Cybersecurity Solution & Delivery

Valuable data is everywhere, it's on premises, in the cloud, on mobile devices and in transit. Unfortunat...
Bryan Afonso Reading Time: 2 minutes