IBM Maximo: Analisando a crontask PMWoGenCronTask

Verificando se esta sendo Work Orders de PMs

SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY FROM workorder w WHERE pmnum IS NOT NULL AND istask = 0 order by reportdate desc

Contando a quantidade

SELECT REPORTDATE,REPORTEDBY,count(1) as CNT FROM workorder w WHERE pmnum IS NOT NULL AND istask = 0 group by REPORTDATE,REPORTEDBY order by reportdate desc

= Ver também =


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