Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Project Status LiveReport
Joe_Rovito_(jrovito_(Delete)_2261134)
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....