Reviewing active users

Although BMC MyIT does not check for license usage, we provide a SQL script, which a database administrator can run on your database to get a count of logins to BMC MyIT.

To review license usage

  1. On your BMC MyIT Server, locate the following scripts in the installdirectory\ddl\utils directory, where installDirectory is the directory in which BMC 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.
  2. From the BMC MyIT database, run the appropriate usage-admin.sql script.
    For a description of available parameters and example queries, check the contents of the 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:

  • 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.

Related topics

License entitlements

FAQs and additional resources

Was this page helpful? Yes No Submitting... Thank you


  1. Jijil Ghosh

    Hi Team

    The SQL file is under ddl folder so kindly modify the location section. Also you need include one more line stating we need to put the actual DB Name for My IT.

    For eg: default value [Myit].[myit].XXX --> [(Actual MYIT DB Name)].[(Actual MYIT DB Name)].

                  [MyIT].[myitsys].XXXX -->[(Actual MYIT DB Name)].[(Actual MYIT DB Name)].





    Nov 01, 2016 05:00
    1. Bhakti Paranjpe

      Hello Jijil,

      Thank you for your comment. I will confirm with the SME and make the suggested changes.


      Nov 02, 2016 12:49
    1. Bhakti Paranjpe

      Hello Jijil,

      I have corrected the directory location and also added a note about setting the actual database name and schema names to the topic.



      Nov 16, 2016 04:03