Reviewing active users
You can use the following methods to view the number of users logging in MyIT:
- MyIT Active User Report—a web report displaying the number of users who logged in to MyIT during a specified period of time.
- REST API call—opening the API endpoint while authenticated as a MyIT administrator.
- SQL scripts—database queries run on your database, which get a count of the logins to MyIT. The queries can be run by a database administrator.
This topic provides the following information:
A similar report to view the number of active users in BMC Remedy with SmartIT (Smart IT) is available. For more information about that report, see from the Smart IT online documentation.
To check license usage, use the BMC License Collection Utility. For information about those reports, see Reports overview in the BMC License Collection Utility online documentation.
The following video (5:27) demonstrates the three methods for monitoring active users:
MyIT Active User Report
MyIT provides licenses on a per user basis. The MyIT Active User Report provides information about the active users in your MyIT environment. Users are considered active when they actually log in to MyIT. Use this report to find out how many users in your organization are actively using MyIT and derive the number of unused or idle licenses.
This section provides the following information about the MyIT Active User Report:
Overview of MyIT Active User Report
The following table provides an overview of the MyIT Active User Report:
|Inputs to the report||The report fetches data from the MyIT database and the Social database, and displays records from the date when MyIT was deployed in your environment, through the date when you generate the report.|
|Output of the report|
The report displays the following output:
|Location of the report|
The report is located in MyIT Administration Console, under More > Reports.
|Additional features||The following list specifies the additional features of the report:|
|Limitations of the report||Currently, the report does not provide the following features:|
Example scenario of using MyIT Active User Report
Allen is a MyIT Administrator and he wants to review how many users in his organization are actively using MyIT. Allen uses the Active User Report and specifies a date range for last six months to generate the report. The report shows the total active users on all types of devices are 1900. He knows that his organization has 2000 MyIT licenses. With this information, Allen concludes that in the past six months, 1900 users actively used MyIT and 100 licenses were unused. Allen exports the report to a CSV format and uses it as a compliance and audit report.
Before you begin
- Ensure that you are a member of the MyIT Admin or MyIT Super Admin permission group.
- The report is available by default and you do not need to do any additional configurations to view the report.
- You can view the data only for your own tenant.
- In a clustered MyIT environment, you can view the data only for the current tenant.
- Ensure that the MyIT Administration Console is accessible.
To use the MyIT Active User Report
The MyIT installation also contains scripts that you can run to get license usage information. A database administrator runs the scripts on the MyIT database and get a count of logins to MyIT. The scripts contain example queries and a description of the available parameters.
To use the SQL scripts
- On your MyIT Server, locate the following scripts in the installDirectory \utils where installDirectory is the directory in which MyIT was installed:
- user-admin-oracle.sql—Review usage on an Oracle database.
- user-admin-sql-server.sql—Review usage on a Microsoft SQL Server database.
- From the MyIT database, run the appropriate usage-admin.sql script.
You must set the actual database name and schema names in the SQL statements in the scripts. For example, if MyIT_DB_Name, Business_Schema_Name, and System_Schema_Name are the actual database and schema names, you must make the following changes in the SQL statements:
More instructions are available in the sql-instructions.txt file, which is located in the installdirectory\ddl\utils directory.
from the BMC Remedy with Smart IT online documentation