1.How to achieve Number of ITIL Process licenses allocated to Client members

[Research]

Hi 

1. Has any one worked on Reports of ITIL process Licenses allocated to particular client members.
if yes or have an idea please guide me.

2. To Generate  the report of Agent Utilization report spent on tool like iteractions,Incident/Request, chat etc
time spent on tool and activity metrics like Login, break, Logout.
Kindly help me.

Thanks.

[Harshal Aditya]

Hi @Research ,

Hope you are doing well.

Please refer the thread below -

https://www.servicenow.com/community/now-platform-forum/where-to-check-license-information-in-servic...

In the sys_user table we have last login date field. From here you can get the last login time of the user

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

[Tushar]

Hi @Research ,

A script like below can be useful - 

var MyScriptInclude = Class.create();
MyScriptInclude.prototype = {
  initialize: function() {},

  getNumberOfITILProcessLicenses: function(clientId) {
    var licenseCount = 0;
    var licenseGr = new GlideRecord('license_table'); // Replace 'license_table' with the actual table name for ITIL process licenses.
    licenseGr.addQuery('client_member', clientId); // 'client_member' should be the reference field on the ITIL process licenses table that links to the client member table.
    licenseGr.query();

    while (licenseGr.next()) {
      licenseCount += parseInt(licenseGr.getValue('number_of_licenses'));
    }

    return licenseCount;
  },

  type: 'MyScriptInclude'
};

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Regards,
Tushar

[LearnUseThrive]

Make sure you're including all the Fulfiller roles. Go through this demo to set up Subscription Management on the instance. You'll take the Fulfiller roles, get the groups that grant those roles, and then use the subscription to count users in the group.

https://www.youtube.com/watch?v=QUxeEKQEksc#33m44s

Warning!: Users assigned a role without a group inheritance won't be counted. You'll need to count those yourself with some usersrole searches.

[Research]

Hi @Harshal Aditya  @Tushar   @LearnUseThrive 
Thankyou for the solution
can you also please guide me on

2. Report of Agent Utilization. Agent spent on tool like interactions, Incident/Request, chat etc
time spent on tool and activity metrics like Login, break, Logout.
Kindly help me.