Focal Point
[SOLVED] Resource Analyser Server Location

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6987076826

February 11, 2013, 10:36 AM
Mike_Lombardi
[SOLVED] Resource Analyser Server Location
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

SMSERVERS Segment
SMSESS Segment
SMRPCS Segment
SMRPCCMD Segment
SMRPCWF Segment
SMQUERY Segment
SMCMDLN Segment
SMGOVEND Segment
SMRMTS Segment
SMFNCTNS Segment
SMRELTNS Segment
SMFROMS Segment
SMCOLMNS Segment
SMAUDIT Segment

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


_______________________
*** WebFOCUS 8.1.05M ***
February 13, 2013, 10:36 AM
Tom Flynn
WHENCE RMLDB MASTER
-EXIT

Answer:
 
D:\ibi\srv77\home\catalog\rmldb.mas

Your path may be different...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 13, 2013, 11:12 AM
Ian Dalton
.....yes WHENCE saves alot of searching...
Here is a bit of code to produce a report that maybe of use...

SET &ECHO=ALL;
-SET &&DATE_TODAY = &DATEDMYY;
-SET &COMPNAME = FGETENV(12,COMPUTERNAME,12,'A12');
-RUN

-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

FILEDEF IBIMRUSR DISK e:\ibi\WebFOCUS76\utilities\IBIMRUSR.TXT
-*FILEDEF IBIMRGRP DISK e:\ibi\WebFOCUS76\utilities\IBIMRGRP.TXT
-*FILEDEF IBIMRDOM DISK e:\ibi\WebFOCUS76\utilities\IBIMRDOM.TXT
-RUN
SET ALL=ON
SET PCOMMA=ON
SET MSG=ON
DEFINE FILE IBIMRUSR
TOKEN1/A40 = GETTOK(USER_PROP, 256, 1, ',', 40, TOKEN1) ;
TOKEN2/A40 = GETTOK(USER_PROP, 256, 2, ',', 40, TOKEN2) ;
TOKEN3/A40 = GETTOK(USER_PROP, 256, 3, ',', 40, TOKEN3) ;
TOKEN4/A40 = GETTOK(USER_PROP, 256, 4, ',', 40, TOKEN4) ;
TOKEN5/A40 = GETTOK(USER_PROP, 256, 5, ',', 40, TOKEN5) ;
TOKEN6/A40 = GETTOK(USER_PROP, 256, 6, ',', 40, TOKEN6) ;

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.


Alan.
WF 7.705/8.007