please help me how to extract incident by using servers

Community Alums
Not applicable

‎10-20-2023 04:34 AM - edited ‎10-20-2023 04:36 AM

Hi All,


We need the total number of tickets received from last 12 months by using servers.

How to extract it

 

Thanks.

0 Helpfuls
  • 256 Views
1 REPLY 1

Anand Kumar P
Giga Patron

‎10-20-2023 04:47 AM

Hi @Community Alums,

var gr = new GlideRecord('incident');
gr.addQuery('cmdb_ci.sys_class_name', 'cmdb_ci_server');
gr.addEncodedQuery(‘

opened _atONLast year@javascript:gs.beginningOfLastYear0@javascript:gs.endOfLastYear\’);


gr.query();

while (gr.next()) {
gs.print('Incident Number: ' + gr.getValue('number'));
}

Please mark it as solution proposed and helpful.

Thanks,

Anand