What logs or data would we look at to determine how many users are accessing our SMART IT / MyIT server?

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

Methods available depending upon the requirement -

1.) Using API REST call

Login to MY IT/ SMART IT  (i.e. /ux/myitapp).  Use a user with MyIT Admin and MyIT Super Admin groups.
Then user the below API call -
>>  http://Servername:port/ux/rest/system/monitor/user/active/statistics

This call will hold true for both MyIT and SmartIT connections.  If Joe is connected to SmartIT, Mary is connected to MyIT  and you log into MyIT to run the rest call… it’ll report 3 (Joe, Mary and you).
There is no way to determine which app the user is logged into though.



2.) Using SQL query if you want to differentiate between SMART IT and MY IT sessions

Use the below query if you want to determine only users logged into from Smart IT by client. 
For MyIT users, application_id = ‘myit’.
 
select ud.create_date, ud.email, ud.user_id,
  (select max(subt.modified_date) from MyIT.device_token subt where subt.user_pk = ud.pk and subt.os_type = 0 and subt.Application_id='remedyItsm' ) as iOS,
  (select max(subt.modified_date) from MyIT.device_token subt where subt.user_pk = ud.pk and subt.os_type =1  and subt.Application_id='remedyItsm'  ) as Android,
  (select max(subt.modified_date) from MyIt.device_token subt where subt.user_pk = ud.pk and subt.os_type = 3 and subt.Application_id='remedyItsm'  ) as Web
from MyIt.USER_DETAILS  ud where CREATE_DATE>'2015-03-30 10:00:00.000'