afilla
Active participant

FNMEA Classic Report Exports

Jump to solution

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
afilla
Active participant

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
JohnSorensenDK
Moderator Moderator
Moderator

@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.

0 Kudos
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.
afilla
Active participant

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