Usage in Crystal Enterprise 9? 1

[bessebo]

We are getting low on named licenses and I know that there are named users out there who do not use Crystal Enterprise very often at all, if at all. Is there anything within Crystal Enterprise or the CMC, etc that will allow me to see usage of report-running by users?

 

[KingfisherINC]

It might be easier to check when they last logged on.

SELECT SI_NAME, SI_LASTLOGONTIME 
FROM CI_SYSTEMOBJECTS
WHERE SI_PROGID = 'CrystalEnterprise.User'
ORDER BY SI_LASTLOGONTIME

Kingfisher

 

[bessebo]

Is this from the CE90 database? I am a little concerned because I don't see the table CI_SYSTEMOBJECTS when I do into Enterprise Manager and click on Tables under the CE90 database. Does that make sense?

 

[bessebo]

I was able to figure out that I had to use the Query builder. Good thing. I was a little concerned I could not see the tables that you mentioned. I think the results of this query will work for me. Thanks for your help.