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