All License Report

scsharath2 asked a question.

January 23, 2023 at 1:16 PM

All License Report

Hi,

We can see a difference in Shortfall/Availability between the All License view which I assume is an OOB report and the Custom report we build.

Example:

In OOB report the Shortfall/Availability shows -5000 and In Custom Report, I can see it as 0.

I know there can be SQL query logic issues in the Custom report but is there any way to look at the Logic behind the All License report from the SQL developer?

FlexNet Manager Suite On-Premises

Top Rated Answers

ChrisG (Flexera Software)
4 years ago
Are you wanting to look directly in the database to see where data used to populate the All Licenses grid comes from?
I believe this is retrieved from the dbo.Grid_LicenseListModel view in the compliance database. For example:
SELECT *FROM dbo.Grid_LicenseListModelWHERE Name = 'Your License Name'
Expand Post
Selected as Best

All Answers

ChrisG (Flexera Software)
4 years ago
Are you wanting to look directly in the database to see where data used to populate the All Licenses grid comes from?
I believe this is retrieved from the dbo.Grid_LicenseListModel view in the compliance database. For example:
SELECT *FROM dbo.Grid_LicenseListModelWHERE Name = 'Your License Name'
Expand Post
Selected as Best

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →

All License Report