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.

[Priyanka Gupta]

Hi Mahesh,

You can use Updated and Updated by fields on your table for this purpose.

You can also set your conditions as a filter for records and choose columns for your report.  

Is there anything particular you are not able to do in your report?

Priyanka

[maheshchaudhary]

Yes Priyanka, I want to query users based on Roles for example :- I need a report which will have records's last updated Date for Licensed Users.

I am able to get records and their last modified date and user who updated. but i only need licensed users(updated by) and i can't query in condition based on Roles because in condition it doesn't show 'related fields' for 'Updated By' field. for other fields like Opened By or Created By i can query based on their roles in report condition because i'm able to related fields for these by selecting 'show related fields'. i need the same thing for 'Updated BY'  field.

[randrews]

I think the idea here is to show the last time a user with an itil role updated a ticket.. i have a similiar requirement and can't figure a way to do so...

IDEALLY anytime a ticket is updated you could check the roles table and if it is an itil user write a metric... HOWEVER.. the issue there is that the fields on a matric won't let you choose updated by to fire the metric.

[Priyanka Gupta]

You can create a view and join your table with User and User Roles table. Then you can set the filter conditions in your report to get role based information.