CA Service Management

I created a custom query scoreboard and it shows 155 itens (requests and incidents).

If I export its results the excel file contains only 130 data lines.

can you show us your query?

active = 1 AND group.last_name in (\'001-Liberacao MAC ADDRESS\',\'001-Telecom\',\'000BAY - Integrações\',\'000BAY - Desenvolvimento\',\'000BAY - Automação\',\'000BAY - DBA\',\'002ELC-CommandCenter\',\'004RCELL - Segurança N1\',\'N1-CommandCenter\',\'000BAY - Field Service\',\'000BAY - N1 GMC\',\'000BAY - N1 ITSM\',\'000BAY - Aprov Req ELC\',\'000BAY - Aprovação Reembolso\',\'000BAY - N2 GMC\',\'000BAY - N2 Solution Center\')

The problem is weird and I think the following is the rootcause : ã  ç  õ

It could be a noise words.

The better solution is to use UUID value of the specified groups in your custom query. This will eliminate the probability of noise words and also improve the query efficiency.

An example of Stored query with UUID value : group.id=U\'2F3B669D0617174281ED27E35646940F\' AND active=1 AND status!=\'RE\' 

Thanks

ArunavaS