- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- FNMEA Third Party License Server Usage
- 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
Hello, We are trying to mine data out of FNMEA for Third Party (Sentinel) License Utilization for visualization with a took like Grafana but the FlexLM license usage and Third Party License usage appears to be in completely different tables in the DB. We were using this query to visualize the FlexLM data but not sure on the Sentinel (Third Party).
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Afilla,
The third party data is on the same table. I ran your query on my database. I just changed the time id. Please look at the file db_query_sentinel.png.
What name did you give to the vendor daemon for Sentinel? How did you upload the data?
you should see the report log file under the location Reporting -->Report Log Summary as per screenshot in file sentinel_rl.png
Regards,
Paul
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
Hi Afilla,
The third party data is on the same table. I ran your query on my database. I just changed the time id. Please look at the file db_query_sentinel.png.
What name did you give to the vendor daemon for Sentinel? How did you upload the data?
you should see the report log file under the location Reporting -->Report Log Summary as per screenshot in file sentinel_rl.png
Regards,
Paul
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Paul,
Thanks for taking a look. We just named the daemon "Sentinel" and it is working via the 3rd Party Adapter and via the Sentinel to FlexLM converter files that you worked with Tammy Callicott on last year. It appears to be working and we are seeing the data in both the reports and our Grafana dashboard now!
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Afilla,
yes that's right I did not realised it was you guys. glad to see it is sorted now
Paul
