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?
‎Jan 05, 2021 02:36 PM
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
‎Jul 22, 2021 08:04 AM
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,
‎Jan 07, 2021 09:16 AM
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.
‎Jan 12, 2021 03:51 PM
‎Jul 16, 2021 08:46 AM
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
‎Jul 22, 2021 08:04 AM