Primavera 15.1 - Udf query

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

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.

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...

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...

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