cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

FNMEA Classic Report Exports

Our customer is using a Grafana Dashboard Business Intelligence tool to expose data on software and hardware utilization. They want to be able to retrieve usage type reports and high water marks from FNMEA to their Grafana Dashboard. I do not want to give them access to root through the DB to recreate what FNMEA already does. Is there a way they can hit the report inbox or a report query to pull the report data?

(1) Solution

For anyone else that may want to mine data out of FNMEA - this is what we used:

 

SELECT

                UPPER(c.SERVER_HOST) as server_hostname,

                c.DAEMON as vendor,

                a.EVENT_ID as event_type,

                a.EVENT_TIME as start_time_epoch,

                a.LINKED_EVENT_TIME as end_time_epoch,

                a.FEATURE_NAME as feature_name,

                a.PRODUCT_VERSION as product_version,

                a.USER_NAME as user_username,

                a.USER_HOSTNAME user_hostname,

                a.USER_IPADDR as user_ipaddress,

                a.CLIENT_PLATFORM as client_platform,

                a.LIC_COUNT as license_count

FROM flexnetreporting.dbo.RPT_USAGE_LIC_EVENT_153 a

LEFT JOIN flexnetreporting.dbo.RPT_CATALOG_SECTION b

                ON a.CATALOG_SECTION_ID = b.CATALOG_SECTION_ID

LEFT JOIN flexnetreporting.dbo.RPT_VENDOR_DAEMON c

                ON b.CATALOG_ID = c.CATALOG_ID

WHERE EVENT_TIME > 1609459200

View solution in original post

(4) Replies

@afilla 

As the title of this thread specifically says Classic report exports, I suppose that you're limited to classic reporting license wise?

Have you investigated the Generating Command-Line Reports section of the documentation?

I think it may be easier for you to create exports in file formats that you could then import or point towards from the Grafana Dashboard BI tool...

Thanks,

Thanks a ton for the help! We are taking a look. We also realized that you can get the report data from the folder structure on the server so we are also looking into just moving that rif file to the grafana system for ingest.

John, We ended up finding the tables in our DB for the FlexLM usage and are exposing it with Grafana and it is working great.

For anyone else that may want to mine data out of FNMEA - this is what we used:

 

SELECT

                UPPER(c.SERVER_HOST) as server_hostname,

                c.DAEMON as vendor,

                a.EVENT_ID as event_type,

                a.EVENT_TIME as start_time_epoch,

                a.LINKED_EVENT_TIME as end_time_epoch,

                a.FEATURE_NAME as feature_name,

                a.PRODUCT_VERSION as product_version,

                a.USER_NAME as user_username,

                a.USER_HOSTNAME user_hostname,

                a.USER_IPADDR as user_ipaddress,

                a.CLIENT_PLATFORM as client_platform,

                a.LIC_COUNT as license_count

FROM flexnetreporting.dbo.RPT_USAGE_LIC_EVENT_153 a

LEFT JOIN flexnetreporting.dbo.RPT_CATALOG_SECTION b

                ON a.CATALOG_SECTION_ID = b.CATALOG_SECTION_ID

LEFT JOIN flexnetreporting.dbo.RPT_VENDOR_DAEMON c

                ON b.CATALOG_ID = c.CATALOG_ID

WHERE EVENT_TIME > 1609459200