The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Plugin Last Access
Posted: 01 Dec 06 2:49 PM
|
fiogf49gjkf0d Does anyone know if SalesLogix tracks the last time a plugin was accessed by a user?
Our SalesLogix contains many, many, many custom forms. Many of which were created long ago, by people no longer here, for people no longer here.
Many of these forms are released to 'Everyone'.
I would like to remove those not being used.
|
|
|
|
Re: Plugin Last Access
Posted: 01 Dec 06 4:11 PM
|
fiogf49gjkf0d I'm not aware of SalesLogix tracking plugin access but this should be an easy thing to do yourself if you are concerned with forms.
I would add a plugin access tracking table and call it c_PluginTracking or something similar. Include a field for pluginname and LastAccessDate.
Write a script to insert or update the table's row every time it is accessed through launching on the OnOpen or OnChange. Actually the OnCreate might be even better.
Sorry this is short on details. Friday afternoon.....
|
|
|
|
Re: Plugin Last Access
Posted: 01 Dec 06 5:07 PM
|
fiogf49gjkf0d Short answer? No. CreateDate and ModifyDate would apply to when architect created and modified the plugin, not when a client accessed it.
Having said that, here's a post that may help: http://www.slxdeveloper.com/forum.aspx?forumid=6002&postid=2652#2652
Another method I've used in the past is to evaluate the SQL backend for those forms. Are there any records created in the tables they've referenced? Any records created recently? You can use the technique to shave down any excess columns you might have in addition to removing any unused tables.
Lastly there is the cache folder which stores a file according to each pluginid. The cache directory for all users is Documents and Settings\All Users\Application Data\SalesLogix\Cache\(4 digit sitecode). The problem with the cache is that I have files going back to '98 and I bought this computer in 2003 which suggests that the modifydate stored may be the plugin's createdate. I am in a habit of clearing the cache for every major revision so my cache is a very good representation of the plugins I've used in 6.2. What if you're not in the habit of doing that? No worries because the cache folder was different in 5.x so any files you have would at MOST go back to 6.0 if you were ever on that version.
Personally I would go with option #1 and 2 before trying option 3. Returning data from a server is always easier than scanning client computers. Though one could justify making a tool for this very purpose, especially when dealing with a large client base. |
|
|
|
Re: Plugin Last Access
Posted: 04 Dec 06 3:41 AM
|
fiogf49gjkf0d Jeff, if all you are interested is on gathering some Usage data, not necessarily including which user accessed the item, but rather how many times a day or week an item has been accessed, you might consider running SQL Profiler with some filters in place.
If you capture the data properly and then parse it, you might end up with a "Log" of plugin access that could yield the results that you are looking for.
|
|
|
|