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