I have recently activated Resource Analyser and now have access to all sorts of useful stats.
I have a request to show these stats to key contacts within our business units so that their users usage can be reviewed.
As these users do not have "MR Admin" access, I have to copy the detail out into a spreadsheet and sent it to them. I do not want to grant them "MR admin" access.
Are these RA reports saved anywhere on the physical server? I'd like to send them the summary but still enable them to drill down to user level detail. I don't really want to start creating a bespoke report for this as I would rather make use of what Resource Analyser is providing.
The reports I run are currently under Resource Management > Reports > Resource Analyser > Usage Analysis. Would be good if I these were stored on the server in some form.
Have searched the forums but could not find anything related to this subject.This message has been edited. Last edited by: Mike_Lombardi,
WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server. Platform : SQL Server 2005, SSAS 2005 Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
February 12, 2013, 11:27 AM
Mike_Lombardi
I have looked through the RA admin documentation where it details what is included in each of the following segments in RMLDB.MAS
Where are these masters stored? I have looked through baseapp and cannot locate them.
I am hoping that I can create a custom report from this master to produce the output I need instead.
WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server. Platform : SQL Server 2005, SSAS 2005 Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
February 13, 2013, 07:24 AM
CLH
Hi,
Our data from Resource analyzer is stored in an oracle repository and we don't have all of the table due to what we told it to store when configuring it. So we just generated the synonyms for the tables and now report off of those. So you should be able to generate the synonyms for the tables you wish to report off of.
Webfocus 8.0.7 on Windows
February 13, 2013, 10:06 AM
Ian Dalton
Try:- c:\ibi\srv77\home\catalog for the RMLDB.MAS file
-SET &F = '&RFORMAT.(HTML,PDF,EXC2K,EXL07).Report Format:.'; -*SET &RFORMAT = 'PDF'; -*EXIT -RUN DEFINE FILE USAGE RUNDATEA/A8YYMD = EDIT(DATE,'9999$99$99'); RUNDATEI/I8YYMD = EDIT(RUNDATEA); RUNDATE/YYMD = RUNDATEI; RUNDATEYM/YYM = RUNDATE; END TABLE FILE USAGE HEADING CENTER "REPORT of WebFOCUS USAGE (no. of times run) by ACTIVITY by USER across MONTH - up to 31/12/2012" " " "Server: &COMPNAME As at: &&DATE_TODAY Page No. " " " -*PRINT USER TIME COUNT TIME/I8C AND ROW-TOTAL
BY PROCEDURE SUB-TOTAL BY USER ACROSS RUNDATEYM AS '' -*BY HIGHEST DATE -*BY USER -*BY HIGHEST TIME -*WHERE PROCEDURE EQ 'Get_Comment'; -*WHERE PROCEDURE NE 'pm_usage'; WHERE DATE GE '2012-01-01' WHERE DATE LE '2012-12-31'; ON PROCEDURE SKIP-LINE ON TABLE PCHOLD FORMAT &RFORMAT ON TABLE SET HTMLCSS ON ON TABLE SET PAGE NOLEAD ON TABLE NOTOTAL FOOTING CENTER "Run by: &IBIMR_user on: &&DATE_TODAY at: &TOD " " " -IF &RFORMAT EQ 'PDF' THEN GOTO PDFSTY; -MRNOEDIT -INCLUDE HTML_STYLE -GOTO THATSALL; -PDFSTY -MRNOEDIT -INCLUDE PDF_STYLE -THATSALL END -EXIT
_______________________ *** WebFOCUS 8.1.05M ***
February 13, 2013, 11:43 AM
Ian Dalton
Sorry folks - in my excitement I copied in the wrong code (above) - we had an internal system before we switched on RA...... Here is some code - you will need to tweak a bit but it works........
-* Summary of usage by user for a selected date range
-*MRNOEDIT -INCLUDE SAPREF -*SET &BYSORT = IF &BYSORT EQ 'LOWEST' THEN 'HIGHEST' ELSE 'LOWEST'; -SET &ECHO=ALL; -SET &COMPNAME = FGETENV(12,COMPUTERNAME,16,'A16'); -*TYPE &COMPNAME -RUN JOIN CLEAR -*JOIN SMKEY IN SMQUERY TO SMKEY IN SMREQSTS AS J0. -RUN SET ASNAMES=ON TABLE FILE SMQUERY SUM COMPUTE DELAP/D20.4 = SMELAPTIME/10000; COMPUTE DCPU/D20.4 = SMCPUTIME/10000; COMPUTE DIOS/D15 = SMIOS; COMPUTE DROWS/D15 = SMROWS; CNT.SMKEY AS 'REQCOUNT' -*SMFEXLOC -*SMSQLLINE
BY SMUSERID BY SMDATE BY SMTIME BY SMRPCNAME
WHERE SMRPCNAME NE ' ' WHERE SMDATE GE '&FROMDATEyyyymmdd' AND SMDATE LE '&TODATEyyyymmdd' AND SMSERVER EQ '&COMPNAME' ; WHERE SMCONNID EQ SMUSERID; WHERE SMCONNID NE 'WEBFOCUS'; ON TABLE HOLD AS QURY END -*EXIT -RUN ?FF QURY -RUN -*EXIT DEFINE FILE QURY TMPDATE/I8=EDIT(SMDATE); TMQDATE/I8YYMD=TMPDATE; SMMONTH/YYM=TMQDATE; END TABLE FILE QURY SUM CNT.REQCOUNT MIN.SMDATE AS 'MINSMDATE' MAX.SMDATE AS 'MAXSMDATE' DIOS DROWS DCPU DELAP CNT.DST.SMRPCNAME AS 'PROCCNT' BY SMUSERID BY SMMONTH -*BY SMDATE ON TABLE HOLD AS SAUSU FORMAT FOCUS INDEX SMUSERID END -RUN -*EXIT -*?FF SAUSU -IF &LINES GT 0 THEN GOTO :HAVEDATA ; -GOTO :ENODATA; -:HAVEDATA
EMAILADDR/A40=IF TOKEN1 CONTAINS 'email=' THEN TOKEN1 ELSE IF TOKEN2 CONTAINS 'email=' THEN TOKEN2 ELSE IF TOKEN3 CONTAINS 'email=' THEN TOKEN3 ELSE IF TOKEN4 CONTAINS 'email=' THEN TOKEN4 ELSE IF TOKEN5 CONTAINS 'email=' THEN TOKEN5 ELSE IF TOKEN6 CONTAINS 'email=' THEN TOKEN6 ELSE 'UNKNOWN'; DISABLED/A1=IF USER_PROP CONTAINS 'inactive' THEN 'Y' ELSE 'N'; USERIDUC/A48=UPCASE(48,USER_ID,'A48'); END TABLE FILE IBIMRUSR -* USE WRITE AND NOT PRINT TO GET ONE LOT OF ACCOUNT DETAILS PER USER WRITE * EMAILADDR DISABLED BY USERIDUC ON TABLE HOLD AS USERINFO FORMAT FOCUS INDEX GROUP_HREF USERIDUC END -RUN -*?FF USERINFO -*EXIT -RUN JOIN CLEAR * -*JOIN SMUSERID IN SAUSU TO USERIDUC IN USERINFO AS J1. JOIN USERIDUC IN USERINFO TO ALL SMUSERID IN SAUSU AS J2. SET ASNAMES = OFF DEFINE FILE USERINFO PREQCNT/D10.2 = REQCOUNT; TOTRES/D16.2 = DIOS + DROWS + DCPU + DELAP; TDATE/A5 = EDIT(MINSMDATE,'$$$$$$99') | '/' | EDIT(MINSMDATE,'$$$$99$$'); IDATE/A10 = TDATE | '/' | EDIT(MINSMDATE,'9999$$$$'); DDATE/A5 = EDIT(MAXSMDATE,'$$$$$$99') | '/' | EDIT(MAXSMDATE,'$$$$99$$'); ADATE/A10 = DDATE | '/' | EDIT(MAXSMDATE,'9999$$$$'); -*INCLUDE SADHLP END
TABLE FILE USERINFO PRINT REQCOUNT AS 'Number of,Menu Items Run' PROCCNT AS 'Number of,Different,Procedures Run' -*IOS AS 'IO' -*ROWS AS 'ROWS' -*CPU -*ELAP AS 'ELAPSED' PCT.PREQCNT AS '% Total,Requests' -*PCT.TOTRES AS '% Total,Resources' IDATE AS 'First,Access' ADATE AS 'Last,Access' AND COLUMN-TOTAL -*&BYLINE -*BY HIGHEST -*BY SMUSERID BY HIGHEST REQCOUNT NOPRINT BY USER_DESC AS 'User Name' BY USERIDUC AS 'User ID' BY SMMONTH AS 'Month' -*BY SMDATE AS 'Date'
-*WHERE ROLE CONTAINS 'Power'
HEADING "Frequency of Use Summary INCLUDING users that did NOT logon at all" " " "Report Date: &DATEDMYY " "Server Name: &COMPNAME " "Date Range : &FROMDATEyyyymmdd - &TODATEyyyymmdd " " " FOOTING BOTTOM -MRNOEDIT -INCLUDE SAFOOT ON TABLE PCHOLD FORMAT AHTML -*IF &WEBVIEW NE 'OFF' THEN GOTO :NOVIEW2 ; -MRNOEDIT -INCLUDE HTML_STYLE ENDSTYLE -*ON TABLE &SARHOLD FORMAT &SARFMT -:NOVIEW2 -*ON TABLE HOLD AS RESANAL FORMAT FOCUS INDEX SMUSERID END -RUN -*?FF RESANAL -EXIT -*HOLD AS RESANAL FORMAT FOCUS INDEX SMUSERID -RUN JOIN CLEAR * JOIN USERIDUC IN USERINFO TO ALL SMUSERID IN RESANAL AS J3.
-*?FF USERINFO -*EXIT TABLE FILE USERINFO "Frequency of Use Summary " " " "Report Date: &DATEDMYY " "Server Name: &COMPNAME " "Date Range : &FROMDATEyyyymmdd - &TODATEyyyymmdd " " " FOOTING BOTTOM -MRNOEDIT -INCLUDE SAFOOT ON TABLE PCHOLD FORMAT AHTML -MRNOEDIT -INCLUDE HTML_STYLE ENDSTYLE PRINT REQCOUNT IOS ROW CPU ELAP TOTRES AND COLUMN-TOTAL BY USERIDUC BY USER_DESC AS 'User Name' WHERE ROLE CONTAINS 'Power' END -EXIT
-:ENODATA -TYPE SORRY NO DATA MATCHES YOUR DATE SELECTIONS...... -XEXIT
_______________________ *** WebFOCUS 8.1.05M ***
February 15, 2013, 05:26 AM
Mike_Lombardi
Thanks guys. Managed to locate it using WENCE as you suggested.
D:\ibi\srv77\home\catalog\rmldb.mas
I'm not sure if IB configured our RA to used SQL server as the repository asI agree I could create synonyms from that.
For now I will look through Ian's example and see how I get on. Looks like I will have to repoint the FILEDEF.
From what I found on the forums I guess I will have to copy the master from the catalog folder to one of my "live" application folders on the server?
WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server. Platform : SQL Server 2005, SSAS 2005 Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
February 16, 2013, 04:28 AM
Alan B
Mike
The server implicitly includes the path to catalog, so you should not need to copy MFD.