configuration management Questions

I have a query that works as I expect only on some projects. (This is with Harvest r7.1 using an Oracle 10g database.):

SELECT En.EnvironmentName, ST.Statename,
PF.PathFullName || '\' ||IT.ItemName AS "Pathname",
VR.MappedVersion,
TO_CHAR(VR.CreationTime, 'YYYY/MM/DD HH24:MI:SS') AS "Created",
U.Username as "UserID", U.Realname as "Name"
FROM HarEnvironment EN,
HarState ST,
HarView VW, HarVersionInView VV,
HarVersions VR, HarItems IT,
HarPathFullName PF,
Harallusers U
WHERE IT.ItemType = 1
AND EN.EnvironmentName = 'EMERALD3'
AND ST.Statename in ('Coding','Development')
AND EN.EnvObjId = VW.EnvObjId
AND VW.ViewObjId = VV.ViewObjId
AND ST.ViewObjID = VW.ViewObjId
AND VV.VersionObjId = VR.VersionObjId
AND VR.ItemObjId = IT.ItemObjId
AND IT.ParentObjId = PF.ItemObjId
AND U.Usrobjid = VR.Creatorid
order by EN.Environmentname, VR.CreationTime ;

The intent was to list all file versions in the specified project and states in order of VR.CreationTime. However, it seems to always get zero results when the only versions are the BASE (0) versions. Apparently a project newly baselined from a snapshot will show zero results.

How should I change the query to show these BASE versions now being skipped?

Thanks,
Tom

I am a IT Compliance Auditor. Can anyone direct me as to where I might find an audit program for both of these CA products?

I need to perform a security health check and assessment for Endeavor and for Harvest.

Running "si.exe viewproject" in a shell I get the error message

"No MDI GUI window up!"

This happens only with parameter viewproject - other si command are working.

The System is:

MS Windows XP 2002 SP3
MKS Integrity Client 2009 4.10.0.9049, SP 006-01

Any Idea why this happens?

Best Regard, Sebastian.

We are using Telelogic Synergy Release 6.5.4096.

Some users have had repeated problems of Updating a Synergy project, but not getting the latest versions of files, even when no apparent file version conflict exists. For example, a folder with changes in it does not get revised to the next folder version with the new files in it.

The Update hasn't failed (no failed message in the "Messages" window), but the user's copy of the project is still not up-to-date with regard to that folder and its files.

Normally, our method has been to use "Sync Work Area", handle that set of files, then do the "Update" on the project.

It has been suggested that we should do the "Update" first, then the Sync. But, I think, the order doesn't matter because Synergy will not update files that have been changed by the user, for whatever reason.

Any idea of what's going on with the updates?

Is there something simple we should be doing to avoid projects not having current file versions when an update seems to work?

Thanks, Mike