Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Number of Focexecs in a Domain
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Number of Focexecs in a Domain
 Login/Join
 
Guru
posted
Hi All,

I was wondering if there's an easy way to know how many focexecs are there in a domain in WF 8.2?

Regards,
Anatess

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.1.05 Windows
 
Posts: 332 | Location: Orlando, FL | Registered: October 17, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Anatess

Try this...
TABLE FILE WF_REPOSOBJ
SUM 
     CNT.WF_REPOSOBJ.WF_REPOSOBJ.OBJNAME AS 'Fex,Count'
BY  WF_REPOSOBJ.WF_REPOSOBJ.PRT_PATH AS 'Domain'
WHERE WF_REPOSOBJ.WF_REPOSOBJ.OBJTYPE EQ 109;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END
  


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1664 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Thanks Chuck, that's interesting...

There are so many 'hidden gems' out there... Just need to do some mining...
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Chuck,
Thank you so much for the help. Unfortunately, I don't have WF_REPOSOBJ. Is that something that requires admin authorization?

Regards,
Anatess


WF 8.1.05 Windows
 
Posts: 332 | Location: Orlando, FL | Registered: October 17, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Anatess

No.. You need to set up and adapter connection to your WebFOCUS repository tables and then create a synonym for WF_REPOSOBJ


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1664 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Number of Focexecs in a Domain

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.