<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: 1 minutes
 
Published on 3/9/20 12:45 PM

RemoteLink Job Assigning and Unassigning using PowerShell, and SQL Server

Introduction

With RemoteLink, an enterprise can now automate clients assignment and/or un-assign to a particular group on the fly.

RemoteLink can run a PowerShell script and SQL Server scripts to perform DML statements against the RemoteLink database. This way, the enterprise has the option to manipulate the tables and data according to their requirements.

RemoteRelief utilizes RemoteLink so an enterprise can execute the script on the RemoteLink server and update the table that is being used by the RemoteLink application to add or remove a client from a session / group.

 

How do you do this?

The enterprise’s operation team will provide a list of clients that need to be removed or added to a group. RemoteRelief will create a RemoteLink session, a PowerShell script, and a SQL Server script for that environment. These components will be added to the enterprise’s RemoteLink server. RemoteRelief will ask you to execute the SQL Server script against the RemoteLink database to create a Stored Procedure the first time only. Once all of these configurations are completed, the enterprise can either schedule the RemoteLink session or execute it on demand. You will still need to update the clients list as needed.

Process

RemoteRelief will customize the following three procedures to achieve this:

  • Setup a RemoteLink session
  • Create a PowerShell script to execute a SQL Server script.
  • Create a SQL Script.
  • Setup a schedule on RemoteLink server to run the session on server only.

 

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

Optimizing the Digital Workspace Experience

Lets start by defining what is a Digital work-space? They provide users with a customized portal that off...
Bryan Afonso Reading Time: 2 minutes

Productivity sky-rocketing with employees working from home

The COVID-19 pandemic has forced those who had the ability to work from home to do so, and has led to a s...
Bryan Afonso Reading Time: 2 minutes

Remote Relief: Utilizing Carbon Black by VMware

Remote Relief utilizes software by VMware to deliver the most up to date device management solutions. Car...
Bryan Afonso Reading Time: 2 minutes