Useful SQL Queries for getting authorized Security Groups and Users for specific application and security option

Getting an authorized Security Groups

select * from APPLICATIONAUTH order by GROUPNAME, APP;
select * from APPLICATIONAUTH where APP = 'SR' and optionname = 'READ';

Getting an authorized User list

select * from GROUPUSER;
select * from GROUPUSER where GROUPNAME in (select GROUPNAME from APPLICATIONAUTH where APP = 'SR' and optionname = 'READ');

Creating an Automation Script for Attribute Launch Point in Maximo 7.6

IBM Support link: http://www-01.ibm.com/support/docview.wss?uid=swg21999062