Hello --
We have a Visio drawing of the cabinet layout of our Data Center.
All of the data about the devices is in our CMDB – a SQL 2005 database. Relevant fields are:
• Hardware device (server, router, etc.)
• Cabinet it is in
• Make/Model that looks up from another table the U height, power consumed, and could link to a graphic image
• Starting U position in the cabinet
There is a database view that shows what devices are in each cabinet, their U location and U height, and the power consumed. From this we can calculate the BTU's produced.
We have connected the Cabinet object to the database, and believe we can associate a picture with a Make/Model, but so far have been unable to make it dynamic – that is to place the objects into the cabinets as the database view is refreshed. I do not want to have to drag every server into the Cabinet shape.
Is there a Visio expert that could help us make this connection?
Thanks,
Jon
I'd be happy to talk,
al
edlund60014 can be
found over on yahoo
one other thing, check out David Parkers book (Visualizing Information with MS Office Visio 2007). He has some good material regarding the basics of building those functions.
al
Edit: Visio Guy removed an actual e-mail address:
aledlund60014 over on yahoo?
close there is no 'al' in the address.
...and there is no "el" in the Christmas alphabet. ::)
But we do still have one here in Chicago ;D
Chicago!?!
You also have wind, and, of course, da Bears.
Chicago???
Yup, if you're into sports we got more than our share (Cubs, Sox, BlackHawks, Bulls, etc.)
al