How to Display results from a script in a table (or similar)

[riaz_mansuri]

Hi,

I have a script which runs fine and displays the results well in the scripts Background.

How do I display the script results in service now as a page and have this script run daily?

var dupRecords = [];

    var gaDupCheck1 = new GlideAggregate('cmdb_ci_computer');

    gaDupCheck1.addQuery('model_category','laptop');

    gaDupCheck1.addAggregate('COUNT', 'asset_tag');

    gaDupCheck1.groupBy('asset_tag');

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

    gaDupCheck1.query();

    while (gaDupCheck1.next()) {

          dupRecords.push(gaDupCheck1.asset_tag.toString());

    }

    gs.print(dupRecords);

Does not have to be anything fancy as long as it displays the results.

Thanks,

Riaz

[Gaurav Bajaj · Accepted solution]

Please replace 28 line with </li>.

Also, I agree with Kalai on this.

[riaz_mansuri]

Top Job!! Thanks

[riaz_mansuri]

Hi Gaurav,

This was very helpful and I now get my list

Any way I can make the Machine Names appear next to the numbers:

The field is called ci

Again doe snot have to look fancy

[Gaurav Bajaj]

Hi Riaz,

gaDupCheck1 is the gliderecord object which is carrying all fields information in it. So you can just fetch out any field's value you need here.

${gaDupCheck1.asset_tag} - ${gaDupCheck1.newFieldName}C

Replace newFieldName in script with your field name.

[Kalaiarasan Pus]

Do you not wish to address the root cause and stop adding duplicates by making asset_tag unique instead?

Jobs are usually for one time action, reminders etc. But I feel here, you should be addressing the root cause rather than adding more technical debt.