Script to help determine License compliance for Maximo Asset Management 7.6.Industry Solutions

Body

License compliance for the Maximo product can be a confusing topic, especially when you include Industry Solutions and any other add on applications.  The document at the link below discusses monitoring usage of software licenses using the License Usage Monitor application.

http://www.ibm.com/support/knowledgecenter/SS8CCV_7.6.0.3/com.ibm.mbs.doc/lic/c_monitor_use_sw_lic.html

This information, however,  may be available for some Industry Solutions and add-ons but not for all.

The attached script will return active users with insert, save, read and delete access to industry solutions and any add on applications.
Please know that In providing this script, IBM does not relieve you of any responsibility for your compliance, it is simply to steer you in
the right direction.

select  mu.userid
,mu.status USER_STATUS
,mp.personid
,mp.status PERSON_STATUS
,mp.displayname
,gu.groupname
,mg.description group_description
,aa.app
,ma.description app_description
,aa.optionname
,mm.moduleapp Module
,mm.elementtype
,mmod.description mod_description
from maximo.maxuser mu
     inner join maximo.person mp on (mp.personid = mu.personid)
     inner join maximo.groupuser gu on (gu.userid = mu.userid)
     inner join maximo.maxgroup mg on (mg.groupname = gu.groupname)
     inner join maximo.applicationauth aa on (aa.groupname = gu.groupname)
     inner join maximo.maxapps ma on (ma.app = aa.app)
left outer join maximo.maxmenu mm on (mm.keyvalue = ma.app and mm.menutype = 'MODULE')
left outer join maximo.maxmodules mmod on (mmod.module = mm.moduleapp)
     where mu.status = 'ACTIVE'
     and aa.optionname in ('SAVE','INSERT','DELETE','UPDATE')
     and mm.elementtype = 'APP'                
     and mm.menutype='MODULE'
     and (aa.app like'PLUS%'
     or aa.app like 'SCHED%')
order by personid

I hope you find this helpful.