Search the Community
Showing results for tags 'monitor'.
I am trying to determine a way to monitor the number of Service Manage Subscriptions using a SQL Measure, so that I can keep a track of our subscription usage and also allow me to predict/plan for any required increases. I have got as far as below, but still are returning more rows than the subscription count, so I must be missing or have a invalid criteria. SELECT distinct a.h_user_id FROM h_sys_accounts a left join h_sys_accounts_roles rg on a.h_user_id=rg.h_user_id left join h_sys_roles r on rg.h_role=r.h_role where a.h_class=1 and a.h_account_status <=1 and r.h_application='com.hornbill.servicemanager' Checking Account is a Full User Account is Active or Suspended Has a Group membership which references the Service Manager application Any idea what I am missing? Cheers Martyn
In the Admin tool under Monitor>Log Files, would it be possible for the filters selected at the top of the screen to be applied to the log download option, i.e. so it is possible to say to export just the security and critical ones? Also, would it be possible to have the option to expand the whole log file when you have filters applied in the UI, rather than having to repeatedly click on load more? Cheers Martyn