Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Resource Analyser Server Location

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Resource Analyser Server Location
 Login/Join
 
Member
posted
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
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Member
posted Hide Post
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
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 176 | Location: Ohio | Registered: October 26, 2006Report This Post
Platinum Member
posted Hide Post
Try:- c:\ibi\srv77\home\catalog for the RMLDB.MAS file


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Expert
posted Hide Post
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
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
.....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 ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Platinum Member
posted Hide Post
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 ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Member
posted Hide Post
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
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Virtuoso
posted Hide Post
Mike

The server implicitly includes the path to catalog, so you should not need to copy MFD.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Resource Analyser Server Location

Copyright © 1996-2020 Information Builders