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.

I3.3.

on premise

SQL

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


Thanks


Outcomes