configuration management Questions

We use Synergy 7.1 on Windows PC.

Do you know if there is a tool to merge word documents (parallel versions) within Synergy ? (msword supertype is binary)

Thank you for your help !

New synergy 7.1 db created for testing, we created custom Process and Process rules based on Synergy's default Process/Process rules (valid and working in other production databases). Now, if I want to create a new project, then I am not able to select any purpose (It shows blank), the message displayed is "No valid purposes for this release", but when I find Process/Process rules, everything is displayed correctly. Even in the Releases, the purposes are correctly set and visible. The problem occurs when I try to create the project.

Please suggest what might be the problem !

I am running a query that returns multiple rows using HSQL. I only want the most current row so I added a group by statement and a MAX statement for the date/time. In problem resolution I have found that the group by is working but the MAX statement is giving me an error. Any ideas?

Query below

select harenvironment.environmentname,
harstate.statename,
harpackage.packagename,
harallusers.username,
harallusers.realname,
haritems.itemobjid,
haritems.itemname,
harpathfullname.pathfullname,
max(harversions.creationtime)

from harpackage

Inner Join harenvironment
on harenvironment.envobjid = harpackage.envobjid

Inner Join harstate
on harstate.stateobjid = harpackage.stateobjid

Inner Join harallusers
on harallusers.usrobjid = harpackage.creatorid

Inner Join harversions
on harversions.packageobjid = harpackage.packageobjid

Inner Join haritems
on haritems.itemobjid = harversions.itemobjid

Inner Join harpathfullname
on harpathfullname.itemobjid = haritems.parentobjid

WHERE HARENVIRONMENT.ENVISACTIVE = 'Y'

AND ( HARENVIRONMENT.ENVIRONMENTNAME LIKE 'EDW%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'EMD%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'HFDR%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'MCWET%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'FRED%' )

AND ( SUBSTR(HARPACKAGE.PACKAGENAME,4,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,5,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,6,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,7,10) = '_20120914_' )

GROUP BY harenvironment.environmentname,
harstate.statename,
harpackage.packagename,
harallusers.username,
harallusers.realname,
haritems.itemobjid,
haritems.itemname,
harpathfullname.pathfullname

ORDER BY haritems.itemobjid,
harversions.creationtime desc,
haritems.itemname,
harpackage.packagename;

I was after some feedback on how far the CMDB concept has been adopted in the earlier stages of the product/system/programe/project lifecycle, i.e. between the initial Bid Stage, through Requirements, Analysis, Design, Development, Integration, Test, to say into a definitive media library (DML or DSL) prior to delivery to the Operational environment.

I would like to know whether there are any organisations out there trying to implement this and if so on which tools and perhaps how far/well this has been achieved.

I am not interested at the moment in knowing what is happening in the operational phases of the lifecycle because I know there is CMDB coverage there.