cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Table/View behind Licenses at Risk page in WebUI

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?

 

(1) Solution
mfranz
By Level 17 Champion
Level 17 Champion

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.

View solution in original post

(2) Replies
mfranz
By Level 17 Champion
Level 17 Champion

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.

Thanks man! As always right on :).