# S564HFM.def: Collects Oracle Hyperion Financial Management information # $Id: S564HFM.def,v 1.4 2009/05/25 11:04:11 mschenke Exp $ # ARCS: $Header: /u02/webapps/workbench/cvs/RDA_4/src/scripting/lib/modules/S564HFM.def,v 1.4 2009/05/25 11:04:11 mschenke Exp $ # # Change History # 20090522 DEM Improve the documentation. =head1 NAME S564HFM - Collects Oracle Hyperion Financial Management information =head1 DESCRIPTION This module collects information for Oracle Hyperion Financial Management. This module is only applicable to Microsoft Windows systems. The following reports can be generated and are regrouped under C: =cut echo tput('bold'),'Processing HFM module ...',tput('off') # Initialization var $HYPERION_HOME = getSetting('HFM_HOME',getEnv('HYPERION_HOME','')) var $ORACLE_HOME = getSetting('ORACLE_HOME','') var $TAIL = getSetting('RDA_TAIL',1000) # Load the common macros run library() var $TOC = '%TOC%' var $TOP = '[[#Top][Back to top]]' toc '1:Hyperion Financial Management' =head2 registry - Registry Information Collects Oracle Hyperion Financial Management information from the Windows registry. =cut report registry debug ' Inside HFM module, gathering registry information' prefix write '---+!! Oracle Hyperion Financial Management Registry Information' call writeRegistry('HKLM\software\HYPERION SOLUTIONS') if isCreated(true) toc '2:[[',getFile(),'][rda_report][Registry Information]]' =head2 version - Version Information Collects latest version information from F<$HYPERION_HOME/logs/hfm/HsvEventLog.log> file. =cut debug ' Inside HFM module, getting version information' var $fil = catFile($HYPERION_HOME,'logs','hfm','HsvEventLog.log') report version prefix {write '---+ Applications Version' write '---## Information Taken from ',encode($fil) write ' * Only latest version reported' write '|*File Name*|*Version*|' } var %ver = () if loadFile($fil) {loop $lin (grepLastFile('^(.*).*(.*).*') {var ($key,$val) = last var $ver{$key} = $val } } } loop $key (keys(%ver)) write '|',$key,' |',replace($ver{$key},'\.','.',true),' |' if isCreated(true) toc '2:[[',getFile(),'][rda_report][Version Information]]' =head2 hsvevent - HsvEventLog File Collects F<$HYPERION_HOME/logs/hfm/HsvEventLog.log> file. =cut debug ' Inside HFM module, gathering HsvEventLog file' report hsvevent call tail_file(catDir($HYPERION_HOME,'logs','hfm'),'HsvEventLog.log',$TAIL) if isCreated() toc '2:[[',getFile(),'][rda_report][HsvEventLog File]]' =head2 versions - Executable and Library Versions Collects the executable and library versions from F<$HYPERION_HOME/FinancialManagement> and F<$HYPERION_HOME/products/FinancialManagement> directories. =cut debug ' Inside HFM module, gathering executable and library versions' report versions prefix {write '---+!! Version Information' write $TOC } loop $dir (catDir($HYPERION_HOME,'FinancialManagement'),\ catDir($HYPERION_HOME,'products','FinancialManagement')) {loop $fil (grepDir($dir,'\.(dll|exe)$','dir')) {write '---+ Version Information from ',basename($fil) call statFile('p',$fil) write '%BR%' var %inf = getVersionInfo($fil) loop $key (keys(%inf)) write '|*',replace($key,'\012','',true),' *|',\ replace($inf{$key},'\012','%BR%',true),' |' write $TOP } } if isCreated(true) toc '2:[[',getFile(),'][rda_report][Executable and Library Versions]]' =head2 oraoledb - Oracle Provider for OLE DB Gets Oracle Provider for OLE DB version. =cut debug ' Inside HFM module, getting Oracle OLE DB version' var ($fil) = (grepDir(catDir($ORACLE_HOME,'bin'),\ '^oraoledb(10|11)?\.dll$','ip')) if testFile('e',$fil) {report oraoledb write '---+!! Oracle Provider for OLE DB Version' write '---## From ',$fil call statFile('b',$fil) write '%BR%' var %inf = getVersionInfo($fil) loop $key (keys(%inf)) write '|*',replace($key,'\012','',true),' *|',\ replace($inf{$key},'\012','',true),' |' if isCreated(true) toc '2:[[',getFile(),'][rda_report][Oracle Provider for OLE DB]]' } =head2 cssxml - CSS.xml File Collects the CSS.xml file in use. It first tries to get the information from registry key C. Otherwise it successively looks in the F<%WINDIR%\Temp> and F<%HOMEPATH%\Localsettings\Temp> directory, =cut var $url = getRegValue('HKLM\software\HYPERION SOLUTIONS\\ Hyperion Financial Management\Server\Authentication','ConnectionInfo') var $req = createRequest('GET',$url) var $rsp = submitRequest($req) report cssxml if isSuccess($rsp) {prefix {write '---+!! CSS.xml File in Use' write '---## Using: ',$url write '' } call writeResponse($rsp) if hasOutput(true) write '' } elsif or(testFile('r',catFile(getEnv('WINDIR',''),'Temp','CSS.xml')),\ testFile('r',catFile(getEnv('HOMEPATH',''),'Localsettings','Temp',\ 'CSS.xml'))) {var $fil = lastFile() prefix {write '---+!! CSS.xml File in Use' write '---## From ',$fil write ' * This is a cache version and may not be the version currently in \ use.' } call writeFile($fil) } if isCreated(true) toc '2:[[',getFile(),'][rda_report][CSS.xml File]]' =begin credits =over 10 =item RDA 4.16: Giacomo Lacava, Karthik Duraisamy, Sudev Alampalli, Steve Johnson, Terry Harber. =back =end credits =head1 COPYRIGHT NOTICE Copyright (c) 2002-2009, Oracle. All rights reserved. =head1 TRADEMARK NOTICE Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. =cut