IBM Maximo: SQL Queries - tabela QUERY

SQL Queries

List saved queries from active users

select OWNER,COUNT(1) AS CNT
from QUERY q, MAXUSER m
where q.OWNER=m.USERID and m.STATUS='ACTIVE'
group by OWNER
order by 2 desc 

Ver também

• Artigos sobre IBM Maximo
• Mais Artigos sobre Cloud / WebDev / Tecnologias