User contributions for Ebasso

12 April 2022

• 21:1021:10, 12 April 2022 diff hist −31‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Maximo CronTask Monitor SQL
• 21:1021:10, 12 April 2022 diff hist +6‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Manutenção da tabela CRONTASKHISTORY
• 21:1021:10, 12 April 2022 diff hist +12‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎No edit summary
• 21:0921:09, 12 April 2022 diff hist −1,553‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎SQL Queries
• 21:0821:08, 12 April 2022 diff hist +60‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Outras tabelas
• 21:0721:07, 12 April 2022 diff hist −4‎ IBM Maximo: SQL Queries - tabela CRONTASKHISTORY ‎ →‎Listar as crontasks executados com maior tempo de duração em MINUTOS nos últimos 7 dias current
• 21:0621:06, 12 April 2022 diff hist +1,911‎ N IBM Maximo: SQL Queries - tabela CRONTASKHISTORY ‎ Criou a página com "= SQL Queries = == Listar o total de crontasks executadas por Ano == select to_char(endtime,'YYYY') as yr, count(1) as cnt from crontaskhistory group by to_char(endtime..."
• 21:0321:03, 12 April 2022 diff hist +597‎ N IBM Maximo: SQL Queries - tabela WFINSTANCE ‎ Criou a página com "= SQL Queries= = Historico = select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CNT from wfinstance where active=0 and deletable=1 group by to_char(STARTTIME,..." current
• 21:0221:02, 12 April 2022 diff hist +414‎ N IBM Maximo: SQL Queries - tabela QUERY ‎ Criou a página com "= 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 OW..." current
• 20:5720:57, 12 April 2022 diff hist +276‎ IBM Maximo ‎ →‎SQL Queries
• 20:5320:53, 12 April 2022 diff hist +10‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Manutenção da tabela CRONTASKHISTORY
• 20:5320:53, 12 April 2022 diff hist −1‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Manutenção da tabela CRONTASKHISTORY

28 March 2022

• 15:1415:14, 28 March 2022 diff hist +125‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Manutenção da tabela CRONTASKHISTORY
• 15:0815:08, 28 March 2022 diff hist −1‎ IBM Maximo: SQL Queries - tabela ESCSTATUS ‎ →‎Listar Escalações na tabela ESCSTATUS current
• 15:0315:03, 28 March 2022 diff hist +139‎ IBM Maximo: SQL Queries - tabela ESCSTATUS ‎ →‎SQL Queries
• 14:5914:59, 28 March 2022 diff hist +2‎ IBM Maximo: SQL Queries - tabela ESCSTATUS ‎ →‎Listar Escalações na tabela ESCSTATUS que não estão mais ativas
• 14:5714:57, 28 March 2022 diff hist −1‎ IBM Maximo: SQL Queries - tabela ESCREPEATTRACK ‎ →‎SQL Queries current
• 14:5614:56, 28 March 2022 diff hist −1‎ IBM Maximo: SQL Queries - tabela ESCSTATUS ‎ →‎Listar Escalações na tabela ESCSTATUS que não estão mais ativas
• 14:5514:55, 28 March 2022 diff hist +639‎ N IBM Maximo: SQL Queries - tabela ESCSTATUS ‎ Criou a página com "= SQL Queries= ==Listar Escalações na tabela ESCSTATUS que não estão mais ativas== select e.escalation from ESCALATION e. where e.active=0 and e.escalation in (s..."
• 14:5514:55, 28 March 2022 diff hist 0‎ IBM Maximo: SQL Queries - tabela ESCREPEATTRACK ‎No edit summary
• 14:5314:53, 28 March 2022 diff hist +667‎ N IBM Maximo: SQL Queries - tabela ESCREPEATTRACK ‎ Criou a página com "= SQL Queries= ==Listar Escalações na tabela ESCREPEATTRACK que não estão mais ativas== select e.escalation from ESCALATION e. where e.active=0 and e.escalation..."
• 14:4014:40, 28 March 2022 diff hist +94‎ IBM Maximo: SQL Queries ‎No edit summary current
• 14:3714:37, 28 March 2022 diff hist −16‎ IBM Maximo: SQL Queries ‎ →‎Login
• 14:3714:37, 28 March 2022 diff hist 0‎ m IBM Maximo: SQL Queries - tabela LOGINTRACK ‎ Ebasso moveu IBM Maximo: SQL Queries - Manutenção da tabela LOGINTRACK para IBM Maximo: SQL Queries - tabela LOGINTRACK sem deixar um redirecionamento current
• 14:3614:36, 28 March 2022 diff hist +19‎ IBM Maximo: SQL Queries - tabela LOGINTRACK ‎ →‎Arquivamento
• 14:3514:35, 28 March 2022 diff hist +981‎ N IBM Maximo: SQL Queries - tabela LOGINTRACK ‎ Criou a página com "= SQL Queries = == Logins nos últimos 2 dias == select * from logintracking where attemptresult='LOGIN' and attemptdate > sysdate - 2 == Listar os Logins por hora ==..."
• 14:3414:34, 28 March 2022 diff hist −669‎ IBM Maximo: SQL Queries ‎ →‎Login
• 14:3114:31, 28 March 2022 diff hist −85‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎SQL Queries
• 14:3014:30, 28 March 2022 diff hist −71‎ IBM Maximo: SQL Queries ‎No edit summary

25 March 2022

• 15:4715:47, 25 March 2022 diff hist +447‎ IBM Cognos: Configurações e Tuning ‎No edit summary current
• 15:4115:41, 25 March 2022 diff hist +678‎ N IBM Cognos: Error message DPR-ERR-2072 when do connection test ‎ Criou a página com " Checking connection on '''Cognos Administration -> Configuration tab -> Data Source Connections -> <conection> -> Test Connection'''. I received the following error: DPR-..." current
• 15:3815:38, 25 March 2022 diff hist −3‎ IBM Cognos: Error message RQP-DEF-0177 when run Cognos report ‎No edit summary current
• 15:3715:37, 25 March 2022 diff hist +22‎ IBM Cognos: Error message RQP-DEF-0177 when run Cognos report ‎No edit summary
• 15:3715:37, 25 March 2022 diff hist +1,450‎ N IBM Cognos: Error message RQP-DEF-0177 when run Cognos report ‎ Criou a página com "Error message RQP-DEF-0177 happens if a dataset is not available for report. This dataset can be a database or a web service. In details we have: UDA-SQL-0528 The XML pa..."
• 15:1915:19, 25 March 2022 diff hist 0‎ IBM Cognos: Configurações e Tuning ‎No edit summary

18 March 2022

• 18:0818:08, 18 March 2022 diff hist +8‎ IBM Maximo: My Configuration Tips ‎ →‎Reduce CronTask History
• 11:4011:40, 18 March 2022 diff hist −3‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Listar as crontasks executados com maior tempo de duração em MINUTOS nos últimos 7 dias
• 11:4011:40, 18 March 2022 diff hist +332‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Listar as crontasks executados com maior tempo de duracao nos últimos 30 dias
• 11:3511:35, 18 March 2022 diff hist +9‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Listar as crontasks executados com maior tempo de duracao nos últimos 30 dias
• 11:3311:33, 18 March 2022 diff hist +7‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎Listar as crontasks executados com maior tempo de duracao nos últimos 30 dias
• 11:3111:31, 18 March 2022 diff hist −2,893‎ IBM Maximo: SQL Queries - CRONTASKS & ESCALATIONS ‎ →‎SQL Queries
• 11:3011:30, 18 March 2022 diff hist +12‎ IBM Maximo: SQL Queries ‎ →‎Escalações
• 11:2911:29, 18 March 2022 diff hist +14‎ IBM Maximo: SQL Queries ‎ →‎Crontasks

11 March 2022

• 13:1813:18, 11 March 2022 diff hist −9‎ IBM Cognos: Configurações e Tuning ‎ →‎Configuring JVM heap size for IBM Cognos Query Service
• 13:0513:05, 11 March 2022 diff hist +166‎ IBM Cognos: Configurações e Tuning ‎ →‎Configuring JVM heap size for IBM Cognos Query Service
• 12:5412:54, 11 March 2022 diff hist +709‎ N IBM Cognos: Configurações e Tuning ‎ Criou a página com "= Configuração e Tuning = ===Configuring JVM heap size for IBM Cognos Query Service=== # Open the Cognos administrative console by selecting Launch > IBM Cognos Administ..."

4 March 2022

• 14:2414:24, 4 March 2022 diff hist +262‎ IBM Maximo ‎ →‎Relatórios

28 February 2022

• 19:2219:22, 28 February 2022 diff hist +116‎ IBM Maximo ‎ →‎Relatórios
• 18:3918:39, 28 February 2022 diff hist −8‎ IBM Maximo ‎ →‎Relatórios
• 18:3918:39, 28 February 2022 diff hist +9‎ IBM Maximo ‎ →‎Relatórios