Visualising Your CMDB With Visio - Square Mile

1 Visualising Your CMDB With VisioDavid CuthbertsonSquare Mile SystemsSquare 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, OtherVirtual InfrastructureNetwork, Servers, Storage, DBMSA pplicationsPC, server, mainframe, SOAS ervicesEnd user, infrastructure, supplierBusiness ProcessesDepartmental, CompanyInformation Resources Web sites on how to create Visio for assetgen Networking for IT Infrastructure Third party webcasts config mgmt focus group ITIL focus group issues and data centresExpectations Why do we want to link Visio diagrams to CMDBs or structured data?

2 What do we mean by automation? Visio 2007 Professional ExtrasExtras we ll cover todayVisio 2007 Resources Microsoft web site Books Linkedin group Visio Enthusiasts Equipment manufacturer web sites Cisco HP, Stencils all Diagrams Help!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 aspectsI Need An Visio Diagram!RequirementDataSourcesDiagramCom mon Diagram Issues Using the same stencils Use of shapes Logical Physical Architecture Use of connectors Consistent and accurate shape data Maintaining hyperlinksThe Process of Drawing a DiagramPurposeGather dataTransfer data to diagram LayoutAdd extra detailSaveSend / publish diagramDefine can we automate?Shape Issues Affecting Automation Shape selection Shape positioning Shape linking Shape data definition Shape data update and maintenance Shape data display Shape hyperlinksA Few Types of Diagrams Service maps Physical Path Logical System Architecture single / multi-technology Process mapsServer DiagramsFloor PlanRack PositionService impactPower SupplyNetwork ConnectionsH/W BuildA Typical CMDB StructureParentChildRelationshipAttribut es 1,2,3 Attributes A,B,COracle Priority.

3 1 Sun V490 Solaris500G DiskSupporting DocsLayers of CMDB StructureHardware InfrastructurePCs, Network, Servers, UPS, Storage, OtherVirtual InfrastructurePCs, Network, Servers, Storage, DBMSA pplicationsPC, server, mainframe, SOAS ervicesEnd user, infrastructure, supplierBusiness ProcessesDepartmental, CompanyTypically, a minimum of 5 layers, Depends totally on scopeInfrastructure is difficult to layernetworkpowerstorageAdding Another LayerIt Starts to Get Complex!This is why we have a CMDBI ncreasing Layers and RelationshipsVisio 2007 Automation Features Programmers toolkit Linking to External Data Shape Data Data graphics Hyperlinks to external dataA 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 selectionThe Process of Drawing a DiagramPurposeGather dataTransfer data to diagram LayoutAdd extra detailSaveSend / publish diagramDefine Data still requiresmanual selectionProduces one diagram at A timeAssetGen ApproachPurposeGather dataTransfer data to diagram LayoutAdd extra detailSaveSend / publish diagramDefine and filter (where practical)

4 Refresh of existingThe AssetGen SolutionFixed Infrastructure(Cabling, Power, Cabinets, Rooms, Buildings)Hardware Infrastructure ComponentsPCs, Network, Servers, UPS, Storage, OtherVirtual Infrastructure ComponentsPCs, Network, Servers, Storage, DBMSA pplicationsPC or server basedServicesEnd user, infrastructure, supplierBusiness ProcessesDepartmental, CompanyAssetGen ConnectPhysical InfrastructureAssetGen SysMapLogical InfrastructureVISUALISATIONI nformation SetsBefore - uncoordinated dataGapsInconsistentNot trustedPartialNo historyCostly to maintainRepeated auditsErrorsLAN/SAN/WAN/Power diagramsServicesSoftwareServersStorageCa binetsNetworksCablingPowerVoiceCoordinat ed database, multiple viewpointsCapacity and connectivity reportsChange impact analysis and audit trailsSpreadsheet outputsService mapsRack, floor plansExamples of Visio Automation Floor plans Rack diagrams Network and other topology diagrams Service maps Data flow diagrams Architecture maps Path diagramsPlus Capacity reportingAudit trailsWorkflowVisualising Your CMDB better understanding of Visio types of automation to reduce manual diagrams can be produced and an understanding of Square Mile techniques and technologyAutomation can givea.

5 Increase in staff productivity projects and operationsb. Confidence in diagrams accuracyc. A portal to more detailed dataNext Steps Training Courses Visio for IT Professionals (2 days)30/6 12/7 Visio automation in-house workshop (1 day) Workshop at Microsoft London HQ29/9 Web content Premier courses and consultancy Videos on AssetGen site Webcasts Downloads AssetGen SysMap Professional evaluation versionThank You For AttendingNow you know about how Visio can work with CMDBs