Create a report

[Shashi K]

My requirement is create a report to how many similar changes have gone multiple CABs, not showing single records of CAB name.

so I have write the script and calling into the report but its not working. please help for this Thankyou.

function getDuplicateValues(table, field){

    var dupValues = [];

    var ga = new GlideAggregate(table);

    ga.addAggregate('COUNT', field);

    ga.addNotNullQuery(field);

    ga.groupBy(field);

    ga.addHaving('COUNT', '>', 1);

    ga.query();

    while (ga.next()) {

        dupValues.push(ga[field].toString());

    }

    return dupValues;

}

[Omkar Kumbhar]

Hello @Shashi K ,

Can you please try using the Javascript: new script_includename.function_name('pass the parameter');

[Shashi K]

where can i use? please show me

[Omkar Kumbhar]

here,

[Shashi K]

Not working