Word 2007 - Visio 2003 - XP SP2 RDP Hyperlinks

[RickD]

Basics: All documents and links are on a corporate intranet and are published
to Sharepoint only accessible by IT staff.

Question:

1) We have a Word 2007 document that contains a list of all software
programs that includes the server they are installed on. We would like to
convert the server name to a hyperlink that would open the published Visio
drawing, Page and Open the custom properties for that server. The drawing
has 5 cabinets per page/tab. Each cabinet contains the shape for the
servers, dlt's etc.

2) Once opened we would like to be able to click on the IP address of the
server (located in the properties we hopefully opened in #1) and have that
open and RDP session or DameWare to that server.

 

[AlEdlund]

A lot of desires, unfortunately not without custom code. How much of the
solution have you already coded? Beyond Word 2007 what other platforms are
involved? What do you mean "published"?
al

 

[RickD]

Yeah lots of desire

Visio is published as an html and stored on a corporate server. It is a
link via Sharepoint. Word, Visio, Sharepoint and IE are the main platforms.
All servers are on Server 2000 or greater. All accessing PC's are XP sp2.
We use DameWare and RDP for remote access via a Juniper Networks SSL.

The purpose of this is to easily locate a server and access it remotely by
IT staff when on call. A typical situation is that a user calls at 2am with
a system down. We are a large company and it would save us quite a bit of
time in locating the offending hardware.

 

[AlEdlund]

I understand completely. There are obviously a number of commercial
solutions that attempt to address this (openview, netview, ms opsmanager,
etc.) . The overriding issue though tends to be the data may be saved on
different platforms (in your case it sounds like office is the primary one)
and trying to coordinate how it interacts. For an enterprise solution it
might be more appropriate to anchor the solution in a serious database and
then use the office interoperability to provide the user interface. In the
short term all that may be required is the ability to query a servers'
ipaddress so that a helpdesk agent can access it via rdp using a command
prompt
small steps
I use a visio drawing with embedded vba as the front end to save the data,
query for devices, draw the necessary diagram based on the current database,
and then point and click to touch the device. (a lot of custom code)
al

 

[RickD]

After playing around some we got this to partially work. By mapping a
hyperlink to the Intranet Web Server
(http://www.<serverhomepage>.com/TSWeb/default.htm?AutoConnect=1&Server=<IP
of Server to RDP to>&FS=0) it allows you to click on the shape on the
published htm visio and open RDp to the Login Screen for that server. In the
above everything inside both sets of <> is replaced with your stuff. Now all
I have to do is figure out how to hyperlink from Word to a shape.

 

[Upreacher]

Rick,

I was trying to accomplish something similar with Visio and Excel.

Did you ever get this working the way you wanted?

Could you respond with some details on what you did, either way?

Thanks,
Mike
"hendrmi-at-hotmail.com