Need a report that shows the date of last updated record for licensed users so We can more effectively manage their license allocation.

[maheshchaudhary]

Hi All, 

 I have a requirement in that 

1. Create report that shows when either Entity or Remediation records were last updated and who the user was.
2. This only applies to Active licensed users 
3. It should only show the user, last updated date, and record type updated (Entity/Remediation)

I’m wondering if in Community anyone else has tried to identify when a user last updated a record (any record really).  Perhaps we look at it from that perspective – the date a user last made an update on any record in ServiceNow? 

  I’m totally open to suggestions here.

[randrews]

unfortunately that will just show the last person to update the record.. so take a call center that opens and assigns tickets out.. .<or any user that JUST does triage> they will generally have few if any records that show they updated them... because they just assign the tickets out.. they don't close them.

[Priyanka Gupta]

You could use Audit History to check for the reassignments over time.

[Priyanka Gupta]

So you mean to say your licensed users are the users with a particular role and you need to filter only for those users using the Updated By field?

[maheshchaudhary]

yes for now, i only want to query for ITIL role.

[Priyanka Gupta]

Is this a custom table?