This documentation supports the 19.02 version of BMC Digital Workplace Advanced.

To view an earlier version, select the version from the Product Version menu.

Reviewing active users

Although BMC Digital Workplace does not check for license usage, you can use the following methods to view the number of users logging in BMC Digital Workplace:

  • BMC Digital Workplace Active User Report—a web report displaying the number of users who logged in to BMC Digital Workplace during a specified period of time.  
  • REST API call—opening the API endpoint while authenticated as a BMC Digital Workplace administrator. 
  • SQL scripts—database queries run on your database, which get a count of the logins to BMC Digital Workplace. The queries can be run by a database administrator.

To check license usage, use the BMC License Collection Utility. For more information about those reports, see Reports overview  in the BMC License Collection Utility online documentation.

Video demonstration

Note

The following video shows an older version of BMC Digital Workplace. The previous product name was MyIT. Although there might be minor changes in the UI, the overall functionality remains the same.

This video (5:27) demonstrates the three methods for monitoring active users:



https://youtu.be/78vlHsSP3dU


Overview of the BMC Digital Workplace Active User Report

BMC Digital Workplace provides licenses on a per user basis. The BMC Digital Workplace Active User Report provides information about the active users in your BMC Digital Workplace environment. Users are considered active when they actually log in to BMC Digital Workplace. Use this report to find out how many users in your organization are actively using BMC Digital Workplace and derive the number of unused or idle licenses.

The following table provides an overview of the BMC Digital Workplace Active User Report:

Inputs to the report

The report fetches data from the BMC Digital Workplace database, and displays records from the date when BMC Digital Workplace was deployed in your environment, through the date when you generate the report.

Output of the report

The report displays the following output:

  • Details about users and the last login date when they accessed BMC Digital Workplace using the Universal Client (UC), Android or iOS clients. 
    The email ID displayed in the report is the user's work email ID, as specified in the CTM:People form. If an email ID was not specified in the form, the Email field on the report remains blank. 
  • Summary information about total unique active users and the number of users who accessed BMC Digital Workplace using different clients.
Location of the report

The report is located in BMC Digital Workplace Admin console, under Reports.

Additional features The following list specifies the additional features of the report:
  • Filtering on a date range. 
  • Navigation between pages of the report.
  • Exporting to CSV format.
Limitations of the report

Currently, the report does not provide the following features:

  • Modification of the report by adding or removing fields.
  • Sharing the report with other users via in-app sharing.
  • Counting users who have only enabled push notifications, or who received push notifications, but did not log in to BMC Digital Workplaceusing any client.
    Such users are not considered active and the report does not count those users. The report counts only the users who logged in to BMC Digital Workplace.

Example scenario of using BMC Digital Workplace Active User Report

Allen is a BMC Digital Workplace administrator and he wants to review how many users in his organization are actively using BMC Digital Workplace. 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 BMC Digital Workplace and 100 licenses were unused. Allen exports the report to a CSV format and uses it as a compliance and audit report.

Before you use the Active User Report

  • 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 BMC Digital Workplace environment, you can view the data only for the current tenant.
  • Ensure that the BMC Digital Workplace Admin console is accessible.

To use the BMC Digital Workplace Active User Report

To view active user report for a defined period of time, specify the date range and select Filter.

To export a report  to a local Excel file, click Export to CSV.


SQL scripts

The BMC Digital Workplace installation also contains scripts that you can run to get license usage information. A database administrator runs the scripts on the BMC Digital Workplace database and get a count of logins to BMC Digital Workplace. The scripts contain example queries and a description of the available parameters.

Before you use the SQL scripts

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:

  • Change [Myit].[myit].[USER_DETAILS] to [MyIT_DB_Name].[Business_Schema_Name].[USER_DETAILS]
  • Change [MyIT].[myitsys].[user_session] to [MyIT_DB_Name].[System_Schema_Name].[USER_SESSION]

More instructions are available in the sql-instructions.txt file, which is located in the installdirectory\ddl\utils directory.

To use the SQL scripts

  1. On your BMC Digital Workplace server, locate the following scripts in the installDirectory \utils where installDirectory is the directory in which BMC Digital Workplace 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.
  2. From the BMC Digital Workplace database, run the appropriate usage-admin.sql script.

Although BMC Digital Workplace does not check for license usage, you can use the following methods to view the number of users logging in BMC Digital Workplace:

  • BMC Digital Workplace Active User Report—a web report displaying the number of users who logged in to BMC Digital Workplace during a specified period of time.  
  • REST API call—opening the API endpoint while authenticated as a BMC Digital Workplace administrator. 
  • SQL scripts—database queries run on your database, which get a count of the logins to BMC Digital Workplace. The queries can be run by a database administrator.

To check license usage, use the BMC License Collection Utility. For more information about those reports, see Reports overview  in the BMC License Collection Utility online documentation.

Video demonstration

Note

The following video shows an older version of BMC Digital Workplace. The previous product name was MyIT. Although there might be minor changes in the UI, the overall functionality remains the same.

This video (5:27) demonstrates the three methods for monitoring active users:



https://youtu.be/78vlHsSP3dU


Overview of the BMC Digital Workplace Active User Report

BMC Digital Workplace provides licenses on a per user basis. The BMC Digital Workplace Active User Report provides information about the active users in your BMC Digital Workplace environment. Users are considered active when they actually log in to BMC Digital Workplace. Use this report to find out how many users in your organization are actively using BMC Digital Workplace and derive the number of unused or idle licenses.

The following table provides an overview of the BMC Digital Workplace Active User Report:

Inputs to the report

The report fetches data from the BMC Digital Workplace database, and displays records from the date when BMC Digital Workplace was deployed in your environment, through the date when you generate the report.

Output of the report

The report displays the following output:

  • Details about users and the last login date when they accessed BMC Digital Workplace using the Universal Client (UC), Android or iOS clients. 
    The email ID displayed in the report is the user's work email ID, as specified in the CTM:People form. If an email ID was not specified in the form, the Email field on the report remains blank. 
  • Summary information about total unique active users and the number of users who accessed BMC Digital Workplace using different clients.
Location of the report

The report is located in BMC Digital Workplace Admin console, under Reports.

Additional features The following list specifies the additional features of the report:
  • Filtering on a date range. 
  • Navigation between pages of the report.
  • Exporting to CSV format.
Limitations of the report

Currently, the report does not provide the following features:

  • Modification of the report by adding or removing fields.
  • Sharing the report with other users via in-app sharing.
  • Counting users who have only enabled push notifications, or who received push notifications, but did not log in to BMC Digital Workplaceusing any client.
    Such users are not considered active and the report does not count those users. The report counts only the users who logged in to BMC Digital Workplace.

Example scenario of using BMC Digital Workplace Active User Report

Allen is a BMC Digital Workplace administrator and he wants to review how many users in his organization are actively using BMC Digital Workplace. 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 BMC Digital Workplace and 100 licenses were unused. Allen exports the report to a CSV format and uses it as a compliance and audit report.

Before you use the Active User Report

  • 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 BMC Digital Workplace environment, you can view the data only for the current tenant.
  • Ensure that the BMC Digital Workplace Admin console is accessible.

To use the BMC Digital Workplace Active User Report

To view active user report for a defined period of time, specify the date range and select Filter.

To export a report  to a local Excel file, click Export to CSV.


SQL scripts

The BMC Digital Workplace installation also contains scripts that you can run to get license usage information. A database administrator runs the scripts on the BMC Digital Workplace database and get a count of logins to BMC Digital Workplace. The scripts contain example queries and a description of the available parameters.

Before you use the SQL scripts

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:

  • Change [Myit].[myit].[USER_DETAILS] to [MyIT_DB_Name].[Business_Schema_Name].[USER_DETAILS]
  • Change [MyIT].[myitsys].[user_session] to [MyIT_DB_Name].[System_Schema_Name].[USER_SESSION]

More instructions are available in the sql-instructions.txt file, which is located in the installdirectory\ddl\utils directory.

To use the SQL scripts

  1. On your BMC Digital Workplace server, locate the following scripts in the installDirectory \utils where installDirectory is the directory in which BMC Digital Workplace 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.
  2. From the BMC Digital Workplace database, run the appropriate usage-admin.sql script.
Was this page helpful? Yes No Submitting... Thank you

Comments