Table/View behind Licenses at Risk page in WebUI

[ppyrzynski]

Hello everyone. 

Is there a Table or View in FNMSCompliance DB where I can get all the info available on Management->License Compliance->Licenses at Risk page in WebUI from? 

Also, if I go to All licenses and filter by compliance Status, it shows me 3 licenses that are not showing Licenses at Risk page. Any idea what can be the reason?

[mfranz · Accepted solution]

I think, this view might be it:

SELECT *
FROM List_LicensesInBreach

I guess the code of the view should tell what else is being filtered out.

[ppyrzynski]

Thanks man! As always right on :).