Primavera 15.1 - Udf query

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

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.

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