If you’re converting Deltek Vision from 5.1 to 6.1 (SP3) or applying a service pack, breaking out your report server… basically doing anything where you need to test reports… it helps to have good knowledge of who is actually running reports, and what reports.
You can enable report logging in your configuration (configuration/ general system settings/ servers tab) by clicking on the “enable report usage logging” check box.
But then what’s the best way to get a consolidated list of the kinds of reports being run and by whom?
(note: for Vision 5.1 only)
It’s by running this script right here:
select username, foldertype as ‘report area’, roxname as ‘report name’
, count(endquerytime) as ‘Times Accessed’
group by username, foldertype, roxname
order by username, foldertype, roxname