Home Asset Management

License Expiration Dashboard

Peter_MiklianPeter_Miklian Customer Advanced IT Monkey ✭✭✭

Hi Community,

our licensing specialist would be happy if they would have some dashboard with licenses near expiration, e.g. 30 days from now.

Is it possible to achieve this with OData or SQL Table Widget? Does someone has this prepared and could share the code / guide?

I saw similar discussion saying that it's not possible to use relative dates in OData: https://community.cireson.com/discussion/5723/odatatable-chart-widget-how-to-filter-dynamic-date

Maybe something changed since then. Or it would be acceptable to have 2 inputs "Enter (current) date" and "Provide span (days) which would come into calculations of results ExpiryDate < GivenDate+Span and display matching licenses. Thank you.

Sign In or Register to comment.