Expand my Community achievements bar.

Reporting on Unused Items/Null Value

Avatar

Level 9
Its been a couple of years since my Workfront instance was initially configured and I'm looking to do some clean-up. I'm trying to figure out how to create a couple of reports that will show me 2 things: Job Roles that have no one assigned to them (we set up FAR too many) Options in a custom form that have never been selected (we have a list of every product we have ever worked on for our clients, many of which have likely not been active for us since we implemented WF) Is there an easy way to do this that I'm unaware of or, failing that, do any of you happen to be Text Mode Wizards? My low-level OCD and I thank you mightily for any advice you can lend. Anthony Pernice Healthcare Consultancy Group
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10
Hi Anthony, Although you might be able to use the API explorer and noodle out some calls that return the cleanup items you're after, I invite you to also consider using our "http://store.atappstore.com/product/workfront-snapshot/">Workfront Snapshot solution. With it, you could create and download a local copy of your Workfront data into a Microsoft Access format, and then (more easily) write as many SQL queries as you wish to find these type of usage questions to guide your cleanup. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads