HPOpenViewDataExtractionandReportingTheReportingChallengeReportstohelpmakeinformedinfrastructuredesigndecisionsforfutureneedsPlanningDepartment

CorporateManagement

ReportsmeasuringqualityandvolumeofITservicesBusinessManagement

MeasurethesuccessofdeliveringmoreITserviceswhileusinglessresources

MorebandwidthNewITServicesRedesigninfrastructureReasonstoextractandminedatausingPC-basedreportingtoolsAnswerspecificquestionsaboutyourenvironmentThereportcanbesharedinacommonformatSeparaterolesofreportdesignerandreportuserUsecurrentlyexistingtalentandtoolsOpportunitytomergemultiplesourcesofdataintoasinglereportAgendaConcepts-toolsandmethodsHPOpenViewproductreportingNetworkNodeManagerIT/OperationsMeasureWareandPerfViewServiceReporterStrategicreportingconceptsObjectivesUnderstandwhydataextractionandreportingisbeneficialUnderstandtheconcepts,tools,andprocessesinvolvedinHPOpenViewdataextractionandreportingGainadditionalinsightonthereportingcapabilitiesofNNM,ITO,MeasureWare,PerfView,andServiceReporterToolsandMethodsOverviewClientPCODBCorCGI/HTTPDataWarehouse/SQLDatabaseFlatTextFileNon-SQLOpenViewDataStoresExamples:BinarydatafilesLogfilesOpenViewProductExporttofileImportfromfileQueryrequestsandresponsesDSILogfilePCClientsMicrosoftExcel97Powerfulimport/exportcapabilityRunqueriesagainstODBCsourceanddisplayitinspreadsheetPerformstatisticsanalysis,graphing,summarizationusingspreadsheetfunctionalitySeagateCrystalReportsDevelopatemplateonce,thenrunreportsbasedonatemplateExportreportstoHTMLformatPowerfulwizardstogenerateSQLqueriesCapableofgeneratingmanytypesofgraphs,andformattingdatainmanywaysBusinessObjectsPowerfulsoftwarewhichallowsuserstocreatead-hocandperiodicreportsAdministratorscancustomizeBusinessObjectssothatusersenterreal-worldqueries,anddonothavetouseSQLAvailableonNTandUnixplatformsMicrosoftAccessRelationalDatabaseManagementSystem(RDBMS)forWindows95/98/NTplatformIncludesqueryandreportingcapabilitiesIdealforintegratingbusinessandnetwork/system/servicemanagementdataCustomApplicationsITdepartmentsbuild,test,anddeploy“homegrown”applicationsCouldbedevelopedusingMSVisualStudiooroneofmanyotherapplicationdevelopmentenvironmentsDecouplesdatafromapplicationSQLdatabasesandODBCOracleRDBMSUsedbyIT/OperationsandNetworkNodeManagerHPOpenViewsupportsOracle7and8PCClientsuseSQL*NETorNet8toaccessthedatabaseacrossthenetworkConsideredthemostcomplexoftheOV-supporteddatabasesMicrosoftSQLServerSupportedbyNetworkNodeManagerandManageXproductsVersion6.5iscurrentlysupportedCustomersinstallandperformbasicconfigurationofSQLServer--HPOpenViewcreatesdatabaseoncethisisperformedMicrosoftAccess/JetDatabaseJetdatabaseembeddedinManageXandServiceReporterLightweightdatabase--idealforstagingdataforreportgenerationEasytogenerateyourownreportsusingMicrosoftAccessODBC-OpenDatabaseConnectivityThebridgebetweendatasourceandquerytoolUsedforconnectinglocallyoracrossthenetworkStandardsbasedMuchmoreprevalentonWindows95/98/NTplatformthanonUnixDataSourcesaredefinedonasystem,anduserslogintootherdatabasesusingtheseDataSourceNames(DSN)ODBCIssuesODBCdriverversionconflictsUsingODBCacrossthenetworkApplicationbehaviorandconsistencyPerformance,andless“rich”dataHTTPandCGIAccesstoOVdatabasesoverthewebCGIscriptspassSQLqueriestotheRDBMSandreturnresultstotheprocess/userwhichinvokedtheCGIscriptThistechnologyisavailableinNetworkNodeManager6.0Command-lineExecutablesUsedtoexport/extractdatafromanOVapplicationandprocessitfurtherOftenusedasinputtoshellorPERLscriptsExamplesincludeovtopodump(NNM)andextract(MeasureWare)HPOpenViewDatabaseDocumentationEntity-RelationshipdiagramsidentifyandrelatetablestoeachotherDatadictionariesdescribethecontentsofeachtableBetweenthesetwosources,ITdepartmentsshouldbeabletomaketheirownreportsDataSourcesNNMandITOdocumentsusuallyinstalledonmanagement

stationMeasureWaredocumentisnotreferringtoaRDBMS,butis

stillworthreferencingAllofthesedocumentsavailableonthewebat

HPOpenViewNetworkNodeManagerLayoutofnetworkandsystemtopologyStatusofsystemsandnetworkdevicesMeasurementofnetworkdevicesusingSNMPIntegrateswithover300partnerapplicationsDataAvailableinNNMTopology

Events

SNMPInformationNNMTopologyDataBasicinformationregardingnodes

andinterfacesofthedevicesona

networkThe“inventory”ofyournetworkExamplesincludesystemnodes,IP

addresses,androuterinterface

informationNNMEventDataInformationregardingthestatus

ofthedevicesonanetwork

Informationregardingthestatus

ofNNMandthird-party

applications

Informationregardingthreshold

violationsbasedonSNMP-based

dataNNMSNMPTrendDataSNMP-baseddatagathered

viasnmpCollect,focusedon

aspecificattributeTrenddataisthebasisfor

settingperformance

thresholds,whichgenerate

eventswhenexceededExamplesinclude

%InterfaceUtilizationand

networkcollisionsAccessingNNMDataOut-of-the-boxreporting,whichwillbepartofNNM6.1UsetheNNMDataWarehouse,introducedinNNM6.0Usecommand-lineexecutables,whichhavebeenavailableformanyreleasesNNMOut-of-boxReportingWeb-basedreportingpackageshippingwithNNM6.1TightlyintegratedwiththeNNMDataWarehouseReportsintheareaofavailability,exception,inventory,andperformanceConfiguringNNMOut-of-the-boxReportsSelectthereportthatyouwanttobeginseeingonascheduledbasisFollowthewizardthroughthesteps.ThelaststepreviewsyourreportparametersNNMReportingArchitectureDataWarehouseODBCExport,AggregateandTrimNNMEmbeddedRDBMSCustomerRDBMS(OracleorMSSQLServer)

DataCollectorTopologyManagerEventsSystemOperationalDataCrystalReportsExcel(1-2-3)Out-of-boxrptsMSAccessFlowofdataNNMDatabaseEnvironments-DatabasesEmbeddedDatabaseWindowsNTandUNIXOracleWindowsNTandUNIXMSSQLServerWindowsNTOnlyNNMEmbeddedDatabaseCompletelyintegratedintoNNM(Backup,start/stop,configuration)Littlecustomerinteractionrequired--forcustomersnotinterestedindatabaseadministration,justreportgenerationSameembeddeddatabasetechnologyasfoundinotherHPOpenViewproductsNNMandOracleNNM6.0canconfigureOracle7.2.3,7.3.4,and8.0.4tobetheanalyticalrepository(DataWarehouse)Customer-suppliedOraclecancoexistwithotherHPOpenViewapplicationsCustomerscanreadilyuseSQL*PlusandOracleReportstocreatereportsbasedontheDataWarehouseBestsuitedforcustomerswithstrongdatabasebackgroundsandenterprise-levelrequirementsNNMandSQLServerNNM6.0canconfigureMSSQLServer6.5tobetheanalyticalrepository(DataWarehouse)UsesODBCdriverssuppliedwithMSSQLServerBestsuitedforcustomerswithstrongdatabasebackgroundsandenterprise-levelrequirementsNNMInterfaces-ODBCODBCactsasthe“bridge”betweentheDataWarehouseandthereportingtoolODBCispervasiveinNTenvironments,butismuchlesscommoninUnixenvironmentsTheNNMDataWarehousesupportsODBCdriversfromdatabasevendorsonWindowsNTNNM6.0suppliestheODBCenvironmentonUNIXNNMInterfaces-ovwebdataCGIprogramrunningonawebserverthatpassesSQLcommandsfromtheclienttotheDataWarehouseandreturnstheresultsofthatquerytotheuserUnderlyingtechnologyusedinExcel97contribtemplatesPossibleinterfaceforcustomerswhowanttowriteweb-basedtoolstoretrievedatafromtheNNMDataWarehouseCurrently,thisinterfaceisnotdocumentedSampleReports-Excel97NetworkexceptionsandeventsNNMSampleReports-Excel97PerformanceandavailabilityNNMSampleReports-Excel97NetworkandsysteminventoryNNMSampleReports-SeagateCrystalReportsNNMSampleReports-MicrosoftAccessHPOpenViewIT/OperationsDistributedsystemmanagementsolutionAgentsmonitormanyaspectsofmanagedsystemsEventsaresenttomanagementconsole,whereoperatorsorautomatedprocesseshandlethemDataAvailableinITOManytypesofevents,originatingfrommanysources

Statusofmanagednodes

InformationregardingITOoperatorsandadministratorsITODatabaseEnvironmentsandInterfacesOracle7.3.4,Oracle8.0.4,Oracle8.0.5ODBCAccessisavailablewiththeuseofOracleSQL*NETorOracleNet8UseITOdocumentstonavigatethroughITOschemaITODataAccessUsetheITOGUI

Buildyourownreports,usingyourpreferredPCbasedquerytool

UseHPOpenViewServiceReporterITODataAccessUsingtheGUI27predefinedreportsforadministrators,12predefinedreportsforoperators

UsetheActionspull-downmenuforITO

Reportoutputcanbedirectedtothescreen,printer,orfileAddingyourownreportsusingtheITOGUIDevelopanSQLquery

SavetheSQLquerytothefollowinglocation:

/etc/opt/OV/share/conf/OpC/mgmt_sv/reports/<lang>/\

<uniquefilename>.sql

EdittheconfigurationfilewhichindexesreportsintheReportsmenu:

/etc/opt/OV/share/conf/OpC/mgmt_sv/reports/<lang>/admin.rpts

/etc/opt/OV/share/conf/OpC/mgmt_sv/reports/<lang>/oper.rptsBuildingyourownITOreportsusingPC-basedquerytoolsODBCusingOracleSQL*NETITODatabaseQueryrequestsandresponsesSQL*NETclientwithODBCDSNconfiguredSQL*NETlistenerprocessconfiguredandrunningonserverAccessingtheITODatabaseusingODBCUsepreconfiguredODBCDSN“ov_net”

Defaultreport(read-only)userisopc_report

DefaultpasswordisOpC_reportITODatabaseDocumentationEntity-relationshipdiagramfortablerelationships

“HPOpenViewIT/OperationsReportingandDatabaseSchema”definesfieldsintables

WhitePaper“HPOpenViewDataExtractionandReporting”summarizesprocessofextractingdatafromITO

ServiceReporterandITOReportsbasedonITOManagementServerdata

30reportsofferedwithServiceReporter

ITorganizationscanuseCrystalReportstocreateadditionalreportsandpresenttheminServiceReporter

ITOSampleReportsITOMessagesITOSampleReportsITOOperatorsandServerConfigurationMeasureWareandPerfViewMeasureandreporthundredsofmetricsonmanagedsystems

Graphperformanceofsystemsovertime

PerformplanningandcapacityanalysisPerformanceDataBasedondatacollectedbyMeasureWareagents,whichresideonmanagedmachinesDataincludesCPUperformance,memoryutilization,networkutilization,andmanyotherareas“DictionaryofOperatingSystemPerformanceMetrics”hasdetailsregardingmetricsthatareavailableoneachplatformARMDataMonitorapplicationavailabilityandperformanceend-to-end

Standards-based

Measureperformanceagainstpre-definedservicelevelsDisplayingDatainPerfViewDisplaymanymetricsonasystemnexttoeachother,or…

ComparetheperformanceofmanymachinesusingasinglemetricExportingdatafromMeasureWare(1of3)Selectdatasource(logfile)andtemplatetoexportdatafromIdentifydaterangeforexportingmetricsExportingDatafromMeasureWare(2of3)Templatesdefinewhichmetricswillbeexported,andthelevelofaggregationthatwilltakeplaceduringtheexport

TemplatesalsoinstructMeasureWaretoexportdatainaspecificdataformatExportingDatafromMeasureWare(3of3)Oncedatafileis

created,openitin

MicrosoftExcel97

UseMSExcel97’s

GraphWizardto

createthegraphs

youneed

Savethefile,and

distributetoothers

inyourorganizationExportingDatafromPerfView

(1of3)Connecttoappropriatedatasources

SelectsystemstocompareSelectmetrictocomparesystemsonExportingDatafromPerfView

(2of3)Select“ExportData”frompull-downmenuIdentifywhereandhowyouwanttoexportthedataTheresultsofyourexportoperationareshownExportingDatafromPerfView

(3of3)EachmachinethatiscomparedisrepresentedbyacolumnUseExcel97’sDataAnalysistoanalyzedataExaminestatisticalresultsofExcel97’sdataanalysisServiceReporterGatherMeasureWareandITOdataacrossthenetworkCreateeasy-to-readweb-basedreportsWorksrightoutofthebox!ServiceReporterArchitectureDiscoveryReportConfigReportEngineMaintenanceAdminUserInterfaceMasterSchedulerDiscover_ITOGather_ITOGathererEngineCentralReportingDatabaseITODatabaseMetricListsReportTemplatesWebPageReportsSQLNETDCERPCITOManagementSystemMeasureWareAgentsCentralReportingSystemServiceReporter’sInterfaceUsers(suchasline-of-businessmanagersuseawebbrowsertoviewreportsAdministratorsusethisinterfacetoconfigureServiceReporter

Out-of-the-boxReportsinServiceReporterCPUUtilizationMemoryUtilizationNetworkUtilizationAvailabilityTransactionsbasedonARMdataInventory(machineswithMeasureWareagents)ITOMessages(byapplication,severity,etc…)ITOOperatorsMessageacknowledgementITOConfigurationInventory(machineswithITOagents)MeasureWareDataIT/OperationsDataImplementingServiceReporter-GettingMeasureWareDataDiscoveryofMW

agentsonNTDomains

performed

automaticallyMWagentsnotonNT

domainscanbe

manuallydiscoveredOncediscovered,MW

dataisgatheredImplementingServiceReporter-GettingIT/OperationsDataConfiguretheHP-UXITOServerrunopcsqlnetconfontheservertoinitiateandrunSQL*NETlistenerConfiguretheNT-basedServiceReporterConsoleInstallOracleClientsoftwareConfigureSQL*NETconnectiontoITOdatabaseConfigureODBCDataSourceinNTControlPanelConfigure/VerifydatabaseconnectioninServiceReporterBuildingYourOwnReportsforServiceReporterDevelopatemplateusingCrystalReportsSaveCrystalReportstemplatetoadirectoryunderneaththeServiceReporterinstallationSchedulethereportusingServiceReporter’sGUIBuildingtemplatesusingMeasureWareDataDatasourcewillbetheMicrosoftJet(Access)

database,whichispartofServiceReporter

ODBCDataSourceNamewillbe“reporter”

Usethe“ServiceReporterConceptsGuide”to

determinewhichtablesyouneedtousetocreate

yourreportCreatingCrystalReportTemplatesUsingITODataUse“standard”ReportExpert

KeepODBCDataSourceNamesconsistent

Useopc_reportloginifpossible

UseITOdocumentation-don’tjustacceptCrystalReport’sdefaults

CopyandPasteelementsfromexistingtemplatestosavetimeandprovideconsistencySchedulingCreatedReportsinServiceReporter(part1)Copyreporttotemplatesdirectory

UseServiceReporterGUItoaddreportdefinition

Optionally,addreportfamiliestoaddalayeroforganizationtoreportsSchedulingCreatedReportsinServiceReporter(part2)ITOReporttitleasitwillappearonServiceReporter’sindexpage

CategoriesdetermineplacementofthereportinServiceReporter’sindex

LocationoftheCrystalReporttemplate

Directorywherereportresultswillreside.Makesureonlyonereportusesonedirectory.

ThisnameshouldbeconsistentwithallotherITOreports,asdefinedusingServiceReporter’sConfigure-DatabasefeatureNNMandServiceReporterCrystalReporttemplates

basedonNNMData

Warehouse

Easymechanismtoinstall

andscheduleNNMreports

Abilitytodiscover

additionalMeasureWare

agentsbasedonNNM

topologydatabaseUnderInvestigation!SampleReportsPerformanceandAvail