- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: FNMEA Classic Report Exports
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
