License count

[giuseppem]

Hi

I need to know how  count license used in HR Service Delivery application. Assigned Roles, entry in HR Profile or other?

Regards

[jo_2016]

Hello Kiel, 

Does HR license consider service accounts or only actual users based on some criteria? 

[AgatheL]

Hi Kiel,

was applying the following query on the hr profile table (employment_typeINA,E,E1,S,full_time_employee,part_time_employee,contingent,contractor^ORemployment_type=^employment_start_dateISEMPTY^ORemployment_start_date<javascript&colon;gs.beginningOfToday()^employment_end_date>javascript&colon;gs.endOfToday()^ORemployment_end_dateISEMPTY^user.active=true) and still have a difference of 49 licences compared to the number from ServiceNow. Could you please provide the query which is applied by ServiceNow on the table to understand the counting please ?

I added in the query the employment type that we added to our model.

Many thanks,

Agathe

[Peter de Bock1]

hi Agathe,

Below the subscription definition which is created by ServiceNow in our subscription application table "ua_stats_defn".

Employment start date (System Hire Date) is empty .and. Employment end date is empty .and. User Active = true .and. or Employment start date (System Hire Date) is not empty .and. Employment start date (System Hire Date) <= 24-03-2023 .and. Employment end date is empty .and. User Active = true .and. or Employment start date (System Hire Date) is not empty .and. Employment start date (System Hire Date) <= 24-03-2023 .and. Employment end date is not empty .and. Employment end date >= 24-03-2023 .and. User Active = true

Maybe this sorts it out!

regards, Peter 

[Dimitri Destin]

Hi Peter,

Thank you for this info!

Do you know when it is calculated?  

If i go to my subscription overview, i can't see any change in real time, si i suppose a job schedule is setup for this? is it all night? one time per day?

Thanks