BMC MyIT - SQL scripts are missing to review license usage in install directory under utils folder.

Version 2

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    MyIT Digital Workplace


    MyIT 3.2 / 3.3 / 3.4 / 3.5


    BMC online document provide methods to view the number of users logging in BMC Digital Workplace.


    To use the SQL scripts
    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.

    However, we do not find utils folder with SQL scripts in install directory.

    MyIT 3.5
    User-added image




    BMC Recommends you should be using the UI to find out active users from MyIT version 3.3 onwards and the SQL script for older versions. However the scripts are missing in install location for 3.5 and 18.02 versions.

    You can download the utils zip file attached with this knowledge article to review from database.

    Article Number:


    Article Type:

    Solutions to a Product Problem

      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles