visualising your cmdb with visio - square · pdf filevisualising your cmdb with visio david...
TRANSCRIPT
![Page 1: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/1.jpg)
Visualising Your CMDB With Visio
David CuthbertsonSquare Mile Systems
![Page 2: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/2.jpg)
Square Mile Overview
• Develop AssetGen toolsets, training and techniques for operational management of complex IT infrastructure
• Focus areas– Data center management– Connectivity management– Service mapping– System change impact analysis – Documentation techniques– Infrastructure visualisation
• All technologies!
Fixed Infrastructure(Cabling, Power, Cabinets, Buildings)
Hardware InfrastructureNetwork, Servers, UPS, Storage, Other
Virtual InfrastructureNetwork, Servers, Storage, DBMS
ApplicationsPC, server, mainframe, SOA
ServicesEnd user, infrastructure, supplier
Business ProcessesDepartmental, Company
![Page 3: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/3.jpg)
Information Resources
• Web sites– www.squaremilesystems.com– www.assetgen.com videos on “how to create visio”– www.youtube.com search for “assetgen”
• Networking for IT Infrastructure– www.linkedin.com– www.datacenterprofessionals.net
• Third party– www.brighttalk.com Online webcasts– www.bcs-cmsg.org.uk BCS config mgmt focus group– smsg.bcs.org BCS ITIL focus group– www.itsmf.co.uk ITIL issues– www.bicsi.org Cabling and data centres
![Page 4: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/4.jpg)
Expectations
• Why do we want to link Visio diagrams to CMDBs or structured data?
• What do we mean by automation?
![Page 5: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/5.jpg)
Visio 2007 Professional Extras
Extras we’ll cover today
![Page 6: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/6.jpg)
Visio 2007 Resources
• Microsoft web site• Visioguy www.visguy.com
• Books• Linkedin group – Visio Enthusiasts• Equipment manufacturer web sites
– Cisco– HP, others www.visiocafe.com
• Stencils– netZoom www.altimatech.com
![Page 7: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/7.jpg)
Not all Diagrams Help!
![Page 8: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/8.jpg)
Overview
• Using Visio manually• Linking to spreadsheets / databases• Navigating to more detail• Understand the process of diagram creation• Creating & maintaining Visio diagrams automatically• Example
– Visualising a CMDB from different aspects
![Page 9: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/9.jpg)
I Need An Visio Diagram!
Requirement
DataSources
Diagram
![Page 10: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/10.jpg)
Common Diagram Issues
• Using the same stencils• Use of shapes
– Logical– Physical– Architecture
• Use of connectors• Consistent and accurate shape data• Maintaining hyperlinks
![Page 11: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/11.jpg)
The Process of Drawing a DiagramPurpose
Gather data
Transfer data to diagram
Layout
Add extra detail
Save
Send / publish diagram
Define shapes
1.
8.
2.
3.
4.
5.
6.
7.
Where can we automate?
![Page 12: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/12.jpg)
Shape Issues Affecting Automation
• Shape selection• Shape positioning• Shape linking• Shape data definition• Shape data update and maintenance• Shape data display • Shape hyperlinks
![Page 13: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/13.jpg)
A Few Types of Diagrams
• Service maps• Physical• Path• Logical• System• Architecture – single / multi-technology• Process maps
![Page 14: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/14.jpg)
Server Diagrams
Floor Plan
Rack Position
Service impact
Power Supply
Network Connections
H/W Build
![Page 15: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/15.jpg)
A Typical CMDB Structure
Parent
Child
Relationship
Attributes 1,2,3
Attributes A,B,C
Oracle AccountsV6.7DR Priority:1
Sun V490Solaris500G Disk
Supporting Docs
![Page 16: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/16.jpg)
Layers of CMDB Structure
Hardware InfrastructurePCs, Network, Servers, UPS, Storage, Other
Virtual InfrastructurePCs, Network, Servers, Storage, DBMS
ApplicationsPC, server, mainframe, SOA
ServicesEnd user, infrastructure, supplier
Business ProcessesDepartmental, Company
Typically, a minimum of 5 layers,
Depends totally on scope
Infrastructure is difficult to layernetworkpowerstorage
![Page 17: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/17.jpg)
Adding Another Layer
![Page 18: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/18.jpg)
It Starts to Get Complex!
This is why we have a
CMDB
![Page 19: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/19.jpg)
Increasing Layers and Relationships
![Page 20: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/20.jpg)
Visio 2007 Automation Features
• Programmers toolkit• Linking to External Data• Shape Data• Data graphics• Hyperlinks to external data
![Page 21: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/21.jpg)
A Few Issues With Data Linking
• Good for importing, bringing data into Visio• Use data graphics to display appropriate data• Requires good file management• Multiple data sources / gaps/ overlaps cause problems• Manual filtering and selection
![Page 22: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/22.jpg)
The Process of Drawing a DiagramPurpose
Gather data
Transfer data to diagram
Layout
Add extra detail
Save
Send / publish diagram
Define shapes
1.
8.
2.
3.
4.
5.
6.
7.
Linking Data still requiresmanual selection
Produces one diagram at A time
![Page 23: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/23.jpg)
AssetGen ApproachPurpose
Gather data
Transfer data to diagram
Layout
Add extra detail
Save
Send / publish diagram
Define shapes
1.
8.
2.
3.
4.
5.
6.
7.
a. Select and filter data
b. Add/update shapes
c. Create diagrams
d. Layout (where practical)
e. Enable refresh of existing
![Page 24: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/24.jpg)
The AssetGen Solution
Fixed Infrastructure(Cabling, Power, Cabinets, Rooms, Buildings)
Hardware Infrastructure ComponentsPCs, Network, Servers, UPS, Storage, Other
Virtual Infrastructure ComponentsPCs, Network, Servers, Storage, DBMS
ApplicationsPC or server based
ServicesEnd user, infrastructure, supplier
Business ProcessesDepartmental, Company
AssetGen ConnectPhysical Infrastructure
AssetGen SysMapLogical
Infrastructure
VISUALISATION
![Page 25: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/25.jpg)
Information Sets
Before - uncoordinated data
Gaps
Inconsistent
Not trusted
Partial
No history
Costly to maintain
Repeated audits
Errors
LAN/SAN/WAN/Power diagrams
ServicesSoftwareServersStorageCabinetsNetworksCablingPowerVoice
Coordinated database, multiple viewpoints
Capacity and connectivity reports
Change impact analysis and audit trails
Spreadsheet outputs
Service maps
Rack, floor plans
![Page 26: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/26.jpg)
Examples of Visio Automation
• Floor plans• Rack diagrams• Network and other topology diagrams• Service maps• Data flow diagrams• Architecture maps• Path diagrams
Plus Capacity reportingAudit trailsWorkflow
![Page 27: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/27.jpg)
Visualising Your CMDB Summary
1. A better understanding of Visio capabilities2. Different types of automation to reduce manual tasks3. Multiple diagrams can be produced and maintained4. Gained an understanding of Square Mile techniques and
technology
Automation can givea. Increase in staff productivity – projects and operationsb. Confidence in diagrams accuracyc. A portal to more detailed data
![Page 28: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/28.jpg)
Next Steps
• Training Courses– Visio for IT Professionals (2 days) 30/6 12/7– Visio automation in-house workshop (1 day)
• Workshop at Microsoft London HQ 29/9
• Web content– Premier courses and consultancy– Videos on AssetGen site– Webcasts www.brighttalk.com
• Downloads– AssetGen SysMap Professional evaluation version
![Page 29: Visualising Your CMDB With Visio - Square · PDF fileVisualising Your CMDB With Visio David Cuthbertson Square Mile Systems](https://reader030.vdocuments.us/reader030/viewer/2022021501/5a79081b7f8b9a07628b85b2/html5/thumbnails/29.jpg)
Thank You For Attending
Now you know about how Visio can work with CMDBs