How to get a time chart of license usage based on source for the last 7 days

[pdantuuri0411]

How to get a time chart of license usage based on source for the last 7 days.

I tried the monitoring console to get the intended results but, it doesn't seem to give out the results for all source types.

Regards.

[richgalloway]

If the MC has a panel that is close to what you need, copy it to your own app and modify it to do what you want.
Consider starting with the "Daily License Usage" panel in the "License Usage - Previous 30 Days" dashboard.

[pdantuuri0411]

Thank you for the quick reply @richgalloway

I used the below query and got the intended results based on source. However, I have a followup question.

The query gives 10 results and the rest of the results go to "OTHER", What is the criteria on what sources are shown and what sources are included in OTHER.

dmc_licensing_base_usage(dw07apl43.cityofchicago.org,"") | dmc_licensing_usage_all(dw07apl43.cityofchicago.org, dmc_licensing_stack_size_srch, dw07apl43.cityofchicago.org, "s", "") | sort -_time

[to4kawa]

check your search query with command+shift+E OR ctrl+shift+E
and modify timechart with useother=f