AnsweredAssumed Answered

Query (or NSQL) for tasks, from a template, that have never had time logged/zero actuals

Question asked by vtleogal2 on Mar 6, 2015
Latest reply on Jun 22, 2015 by vtleogal2

I have tried several queries and no matter what I do, I keep getting hung up on tasks within a project or by resource . (the results show me for a specific project/resource or task)

here is what I need

Show all tasks (preferably within a specific OBS or I can use the prexternal id ranges) where no one has ever logged time to it.

Basically, we have a template used to create the projects

we need to evaluate if there are tasks that have never been used for time entry across all projects. I just need the task name and id..

Then we can evaluate whether we need to keep those tasks in the template or not.

A query is fine, but if someone has the nsql for this, that will work too - I just need to run it one time essentially.

I don't see a way to get this ootb even with the content package.


on premise


we don't use BOBJ either, so running this against the db is my best route