News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Show actual values of Servers in Visio (2010 Professional)

Started by max232, May 15, 2014, 06:09:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

max232

Hello folks!

I want to map and monitor our little "Server landscape" in Visio. (Show actual values like CPU operating grade, ROM, ping/online, ...)
I don't understand what data source (link data with shapes) I have to choose to show that data on my Visio Diagram.

Possible choices are MS Excel, MS Access, MS Sharepoint Foundation, MS SQL and OLEDB/ODBC Source. I am confused now, because I thought I have to  tell my shapes something like an IP-adess or Host-Name of the servers, so that Visio gets the data directly from that servers?!
(I got the feeling I am completely wrong on how that works, so please clarify me.)

The result should look like you can see in the attachment.

Many thanks in advance,
Max

aledlund

Well the first issue of course comes from
"Show actual values like CPU operating grade, ROM, ping/online," The traditional way of course is to either log on to the device (rdp?) and save the data to some queryable platform (excel, access, sql, etc.). The data can be queried via a program using the MS Windows Management Instrumentation (WMI) and saved.
Once the data has been saved you can use Visio Pro versions to datalink to the information and use datagraphics to display the data.
There used to be a free add-in available on the MS download site to pull some of the data.
Here's an example of some of the things that can be accomplished (intermediate to good coder required).
https://www.youtube.com/watch?v=zSmiaBMtSPg
hth,
al


max232

Thx al for your insights.

Do you know the Name of the add-inn to pull the data from the Servers?




aledlund

what I used as source for many of the routines that I re-built into vb.net were originally posted on TechNet in the vbscript section.
al

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 230 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1070KB.
Tokens: post-login.
Cache hits: 13: 0.00117s for 26,763 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]