DSMU object report excludes family tables

[gchampoux]

The PTC-supplied object report (in Intralink 3.4) does not include any objects/models that are part of a family table (generics or instances). There is a separate report for generics and instances, but I would like to have a single report of all objects/files.

Can anyone recommend a better SQL select statement for the object report that includes the generics?
I don't need the instances, but it would be nice to have them included.

Gerry Champoux
Williams International

[gchampoux]

Thanks to all that replied. However, I should have included more details. The PTC-supplied SQL script I use is to list all files and their vault locations. When we find that there are missing files in a replica, this list is used to identify the source files so we can manually copy to the replicas.

For reasons unknown, the script excludes family table generics and instances. I need at least the generics. I hope someone can suggest an improvement. Here is the script:

SET PAGES 0
set lines 500
set trimspool on
--SET FEED OFF
SET HEAD OFF
SET VERI OFF
SET ARRAYSIZE 1
SPOOL &&1
SELECT PINAME||' REV '||PIVREV||' VER '||PIVVer||' BRANCH '||BRPATH,
' '||FSVPORT||'@'||POOLHOST||':'||POOLPATH||'|'||PIVFMAPNAME||' - '||pivfid
FROM (SELECT DISTINCT
PINAME, PIVREV, PIVVer, BRPATH, FSVPORT,
POOLHOST, POOLPATH, FMAPNAME PIVFMAPNAME, pivfid, PIVFNAME
FROM pdm.pdm_file, PDM.PDM_POOL, PDM.PDM_PRODUCTITEMVERFILE, PDM.PDM_FILESERVER,
PDM.PDM_PRODUCTITEMVERSION, PDM.PDM_BRANCH, PDM.PDM_PRODUCTITEM
WHERE PDM.PDM_POOL.POOLID = PDM.PDM_file.POOLID
and pdm.pdm_file.fid = pdm.pdm_productitemverfile.fid
AND PDM.PDM_PRODUCTITEMVERSION.PIVID = PDM.PDM_PRODUCTITEMVERFILE.PIVID
AND PDM.PDM_BRANCH.BRID = PDM.PDM_PRODUCTITEMVERSION.BRID
AND PDM.PDM_PRODUCTITEM.PIID = PDM.PDM_BRANCH.PIID
AND PDM.PDM_FILESERVER.FSVHOST = PDM.PDM_POOL.POOLHOST)
ORDER BY &2, &3, &4, &5;

SPOOL OFF
EXIT