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
- 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.
- 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:
More instructions are available in the sql-instructions.txt file, which is located in the installdirectory\ddl\utils directory.