Add a link to remote control a workstation.
This was tested with RealVNC and will probably work with other VNC programs that are web accessible.
I set this up on SD Build 6003 using MS SQL 2005.
Here's what you do:
Create a fresh backup, just to be safe. -->
Go to Admin --> Workstation - Additional Fields -->
Create a new TEXT field. --> Label:VNC --> Type:Single-line --> Save
Go to "Inventory" and select a workstation to view details. --> Edit Workstation
In the new "VNC" field, paste this html syntax:
WorkstationName = Computer Name or IP
Port= Whatever port number is configured for the VNC server. Default is 5900.
--> Save --> Test the link (the link only seems to work from the "ViewWSDetails" screen.
__________________________________________________________________________________________________________________
Update all Workstations using SQL:
(If you are not familiar with developing in SQL, please do not attempt). See attached xls file. -->
Execute the SQL code attached to this topic (VNC_CodeBuilder.xls SQL-Select) to search for the Workstation ID associated with each Workstation. -->
You will need to concatenate url syntax with the workstation name (or IP) to build the unique html code for each link. (VNC_CodeBuilder.xls HTML)
There are several ways to create these records. I chose Excel because it illustrates the process (and made it easier for me to follow my own logic). I chose to build the link in Excel and build the SQL (Insert) statement in Excel to generate multiple insert statements. See example below:
The new field that we named "VNC" is located in table Workstation_Fields. The field name will probably be UDF_CHAR1 (depending on whether or not you have created additional fields for "Workstation").
See VNC_CodeBuilder.xls SQL-Insert.
Disclamer: if you manage to hose your system because you couldn't follow these instructions, that's just tough luck. Please don't involve the support team at AdventNet with this project/hack. You are pretty much on your own with this project. Hopefully, you 'll find it to be a useful tip/trick, but it does involve some knowledge of SQL.
Here's what you do:
Create a fresh backup, just to be safe. -->
Go to Admin --> Workstation - Additional Fields -->
Create a new TEXT field. --> Label:VNC --> Type:Single-line --> Save
Go to "Inventory" and select a workstation to view details. --> Edit Workstation
In the new "VNC" field, paste this html syntax:
<A href="http://WorkstationName:port#" target=_blank>WorkstationName</A>
WorkstationName = Computer Name or IP
Port= Whatever port number is configured for the VNC server. Default is 5900.
--> Save --> Test the link (the link only seems to work from the "ViewWSDetails" screen.
__________________________________________________________________________________________________________________
Update all Workstations using SQL:
(If you are not familiar with developing in SQL, please do not attempt). See attached xls file. -->
Execute the SQL code attached to this topic (VNC_CodeBuilder.xls SQL-Select) to search for the Workstation ID associated with each Workstation. -->
You will need to concatenate url syntax with the workstation name (or IP) to build the unique html code for each link. (VNC_CodeBuilder.xls HTML)
There are several ways to create these records. I chose Excel because it illustrates the process (and made it easier for me to follow my own logic). I chose to build the link in Excel and build the SQL (Insert) statement in Excel to generate multiple insert statements. See example below:
use [servicedesk]
insert into [dbo].[Workstation_Fields] (WorkstationID, [color=green]UDF_CHAR1[/color]) Values (29, '<A href="http://WorkstationName:port#" target=_top>WorkstationName</A>')
The new field that we named "VNC" is located in table Workstation_Fields. The field name will probably be UDF_CHAR1 (depending on whether or not you have created additional fields for "Workstation").
See VNC_CodeBuilder.xls SQL-Insert.
Disclamer: if you manage to hose your system because you couldn't follow these instructions, that's just tough luck. Please don't involve the support team at AdventNet with this project/hack. You are pretty much on your own with this project. Hopefully, you 'll find it to be a useful tip/trick, but it does involve some knowledge of SQL.