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;

}

[Shashi K]

but it showing like this 1 record i cab

i want same change record with multiple cabs not a single cab

[Dr Atul G- LNG]

So you want somthing

Which is not OOTB available and I am on still my point, need to script for this and that is time consuming.