Is there a way to tell the last time a report was run

[Brian Lancaster]

We are trying to take a look to see if there are any reports we no longer use.  I did some searching on here but only found really old posts.  They mentioned looking at the report_view table but I do not seem to have that table.  Where can I go see this information?

[Steven Herrmann]

Hey again Brian,

When you click into the report it show should a field for user.  Sometimes this field is populated with a sys_id instead of an actual name so you might need to run a background script to get the actual user's name:

var gr = new GlideRecord('sys_user');
gr.addQuery('sys_id', 'enteryoursysidhere');
gr.query();

while (gr.next()) {
    gs.info(gr.getDisplayValue());
}

If my reply helps you at all, I'd really appreciate it if you click the Helpful button and if my reply is the answer you were looking for, it would be awesome if you could click the Accepted Solution button!  🙂

I hope this helps also!

Steve

[Brian Lancaster]

Are you referring to report_stats?  Is so the only user related filed I have is for the person who created the report and I had to dot walk to that.

[Adam Stout]

No.

[niharika2123]

Hi, 

Report_stats table has a last run field on it which tells you when the report was last used. 

Thanks,

Jhansi