Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Primavera 15.1 - Udf query

5 replies [Last post]
pulkit verma
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 11 Jul 2014
Posts: 10

Hello Folks ,

Just need to ask about UDF removal / hide

- We are having lots of UDFs which are not using from long time but  consuming lots of data. Is there any way we can filter out which udf is not in use so that we can remove the UDF. Also need to take backup for udf .

Pulkit Verma

+91-7095956111

Replies

Steven Auld
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Sep 2017
Posts: 126

The only way that I can think of to see exactly what is being used by each project is by directly querying the data in the database & not in the P6 application.

The Following SQL gives the correct results when testing in a SQLite database:

SELECT DISTINCT
PROJECT.PROJ_SHORT_NAME AS 'Project Code',
UDFTYPE.UDF_TYPE_LABEL AS 'UDF Type',
COUNT(UDFVALUE.FK_ID) AS 'Number of Assignments'
FROM
UDFVALUE
INNER JOIN
UDFTYPE ON UDFVALUE.UDF_TYPE_ID = UDFTYPE.UDF_TYPE_ID
INNER JOIN
PROJECT ON UDFVALUE.PROJ_ID = PROJECT.PROJ_ID
GROUP BY
PROJECT.PROJ_SHORT_NAME,
UDFTYPE.UDF_TYPE_LABEL

This should give you a list of the Projects in the Database that have UDF's assigned to them, the Name of the UDF as given in the P6 Application List along with the number of times that UDF has been assigned per project.

Please note that this is not all of the UDF's & will only show the number of UDF's assigned to each project. There are a number of different UDF's all saved into this table that are not based on a Project (Resources UDF's etc).

Unfortunately you cannot easily backup just the UDF's, as the remaining project data may change over time - best option would be to archive the entire project in either XER or XML format & save these files outside the database so that they could be fully restored if required at a later date.

Please note that this has been tested against the P6 SQLite Database only - check with your Database admin before running.

Hope this helps.

Steven

pulkit verma
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 11 Jul 2014
Posts: 10

Hi ,

Its ok server ......

As you said sending mail but to whoom ?

only things is there are lots of UDF and There are lots of User base so how to figure out which UDF are gettign use and which one is not in use...

pulkit verma
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 11 Jul 2014
Posts: 10

Hi ,

Its ok server ......

As you said sending mail but to whoom ?

only things is there are lots of UDF and There are lots of User base so how to figure out which UDF are gettign use and which one is not in use...

Santosh Bhat
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 15 Apr 2005
Posts: 381

Unfortuantely there is no way within P6 to inspect which UDF fields are being used by whcih projects. One option is to prefix the ones that you thinki are not being used with a "ZZ" so they appear at the bottom of all data fields - then wait to see who complains!

Otherwise, you can use tools like P6 Audit from Emeral Associates which can actually run reports against your P6 database to determine which projects are using UDF field and then make a decisions on whether it can be simply deleted or not.

Zoltan Palffy
User offline. Last seen 3 days 10 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

is this on a server ?

if so or if not send out an email asking what UDF's are being used. If you do not hear back by XXXXXXX date then it wil be deleted.

you will know shortly if there is an issue