Report which can show me who has nothing done.......

Hello I do need a report which can show me who hast nothing done in a period of time. This report is very important, because it could show us, if there are some users who won¿t need a livelink licence anymore. Do you have an idea how to create such a live report?Thanks for your help.Peter

Find more posts tagged with

Comments

John_Shoun

These types of things can be a challenge because you are looking for an absense of data.One way to do that is an outer-join, but those SQL queries can be very expensive. Besides, I always get confused about where the "(+)" thing goes.A simpler query uses the minus operator to take all users and then subtract the active ones. You are left with the ones that have done nothing:---------------select name, lastnamefrom kuafwhere id in ( select id from kuaf where type = 0 and deleted = 0 minus select distinct userid from dauditnew where auditdate between '01-jan-07' and sysdate);---------------All of the above applies to Oracle. You mileage will vary with SQL-Server.

Jeff_Brown_(G*_ECM_Champ)

Wouldn't it be easier to get all usage data, export it to Excel and then manipulate it there to get the results you want?

Peter_Arens_(p_arenspe_-_(deleted))

What would you export to livelink?How would you export data from Excel to livelink?

Karl-Heinz_Jakob_(sglcadmin1a_-_(deleted))

There is an easy way to get the data from a LiveReport into EXCEL. In EXCEL choose "Data" - "Import External Data" - "New Web Query" and then copy the URL (Short Cut) of your LiveReport into the address field, press "Start". After connecting to Livelink you will get some nice little yellow arrows, click on the inner field of the result of your LiveReport, press "Import" and OK. That's it. Hope that helps.