Testing reports – useage stats for Vision 5.1 only

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’
from reportlog
group by username, foldertype, roxname
order by username, foldertype, roxname

Now that was easy wasn’t it?
p.s. in Hong Kong I’ve actually left the office ad midnight a few times because I was coinciding with schedules in the States, like with support, or fellow consultants.  Those times I left at midnight, there were still people in the office.  Hong Kongers are known for their work ethic.

3 thoughts on “Testing reports – useage stats for Vision 5.1 only

  1. Loren, thank you for this post–very interesting. I ran the query and noticed that even our favorite reports use the roxname of the standard report. I searched through the options and didn't find any reference to the favorite name. Do you have any idea how I might find that? There were many favorite reports created prior to my arrival and I would really like to see who is running which ones. I suspect many can be retired. Thanks!

  2. You're welcome.

    2 items:

    1. this only works in Vision 5.1 … in 6.1 the report logging is stored somewhere else (currently looking for it)

    2. here's a script that will display your favorites too:

    select username, foldertype as 'report area', roxname as 'report name', left(roiname,len(roiname)-21) as 'favorite name'
    , count(endquerytime) as 'Times Accessed'
    from reportlog
    group by username, foldertype, roxname, left(roiname,len(roiname)-21)
    order by username, foldertype, roxname, left(roiname,len(roiname)-21)

Comments or questions for Loren?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s