Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments. Click here to view the documentation for the current version.

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.

Note

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

Comments

  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)].

     

     installDirectory/ddl/utils

    Regards,

    Jijil

    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.

      Regards,
      Bhakti

      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.

      Thanks,
      Bhakti

       

      Nov 16, 2016 04:03