Project Status LiveReport

Hello everyone, I require help in creating a LiveReport that displays all users with permission, their type of permission, and last login/access to a project.This is just one of many LiveReports that will aid Management in having a birds eye view of the systems usage. Does anyone have any similar LiveReports that would aid Management in obtaining a quick view of the Livelink system usage?Any help is greatly appreciated.Thanks

Find more posts tagged with

Comments

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

You'll have problems getting the last access to a project as LL does not store this info - it is stored in your Web Server logs (so if you can get that into a Database you could get hold of it). The rest should be doable.

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

Check whats in DAUDIT table ...Maybee you can find out what items belonged to a particular project ....select max(auditdate) from daudit where dataid in (select dataid from dtree where ownerid=9601)where ownerid is equal the project -dataidyou will miss some goodies like subproject ... but then you either need to have a Master in SQL or do it using a request handler with SDK that is the preffered way to do more complicated reports as you can do what you want and also present it using HTML....Regardsmagnus@ids.sePs. You also miss as SunValleyFoodAdmin whn the user just click on a folder in a project as that is just stored in the WEBserver log.... but who needs employees that just browse....