Creating a Subscription Table Report with Different Last Login Criteria Based on Subscription Type

mregragui_ext
Tera Contributor

‎09-04-2023 06:52 AM

Hello ServiceNow Community,

I Am looking to create a report in the "license_details" subscription table, and I need it to display users' last login times based on their subscription type. Specifically:

  1. For subscription types labeled as "Approvers," I want the report to show users' last login times for up to the past 6 months.
  2. For subscription types labeled as "Fulfillers," the report should display users' last login times for up to the past 3 months.

Could someone please guide me on how to set up this report to achieve these specific criteria? Any assistance or suggestions would be greatly appreciated.

Thank you in advance!

0 Helpfuls
  • 1,659 Views
6 REPLIES 6

Maik Skoddow
Tera Patron
Tera Patron
In response to mregragui_ext

‎09-05-2023 05:38 AM

So each time when you are not able to explain a question in a way that someone can understand it, you will create another question? If everyone did it the way you do, the community would be full of useless questions and answers. 

And sorry, also your second question cannot be understood by me. Someone else might have more luck.

0 Helpfuls

HUB_RL
Tera Contributor
In response to Maik Skoddow

‎07-16-2024 10:50 AM

Hi Maik, 

 

I have a similar issue and was following your example as it appears to be what I am looking to accomplish.  However for me in the ua_app_usage table, the subscription identifier field is not populated. Why would that be and how might I populate with the data from the license_details_item table? I am newer to ServiceNow so please forgive my lack of knowledge in this area. 

 

Thank you in advance for your time. 

Rohit

0 Helpfuls