Need to know how intensive is Harvest being used
Article ID: 136408
Updated On:
Products
Issue/Introduction
We are needing a way to measure how our developers are using Harvest. We suspect they are using their own version control software and only checking into Harvest the finished release. Is there a query that can let us know if this is happening?
Environment
Release : 13.0.3
Component : CA Harvest Software Change Manager
Resolution
This query will give you the total number of versions, and the
number of non-zero versions for each active project in your Harvest
database. It can let you know if the users are only checking in the files one time, or if they are checking out, changing and checking in new versions
SELECT
HARENVIRONMENT.ENVIRONMENTNAME,
ALLVERSIONS."TOTAL-VERSIONS",
NONZEROVERSIONS."NON-ZERO-VERSIONS"
FROM
HARENVIRONMENT
LEFT JOIN
( SELECT
HARENVIRONMENT.ENVOBJID,
COUNT(DISTINCT
HARVERSIONINVIEW.VERSIONOBJID) AS "TOTAL-VERSIONS"
FROM
HARENVIRONMENT
INNER JOIN HARVIEW ON
HARENVIRONMENT.ENVOBJID = HARVIEW.ENVOBJID
INNER JOIN
HARVERSIONINVIEW ON HARVIEW.VIEWOBJID = HARVERSIONINVIEW.VIEWOBJID
GROUP BY
HARENVIRONMENT.ENVOBJID
) ALLVERSIONS ON HARENVIRONMENT.ENVOBJID =
ALLVERSIONS.ENVOBJID
LEFT JOIN
( SELECT
HARENVIRONMENT.ENVOBJID,
COUNT(DISTINCT
HARVERSIONS.VERSIONOBJID) AS "NON-ZERO-VERSIONS"
FROM
HARENVIRONMENT
INNER JOIN HARVIEW ON
HARENVIRONMENT.ENVOBJID = HARVIEW.ENVOBJID
INNER JOIN
HARVERSIONINVIEW ON HARVIEW.VIEWOBJID = HARVERSIONINVIEW.VIEWOBJID
INNER JOIN
HARVERSIONS ON HARVERSIONS.VERSIONOBJID = HARVERSIONINVIEW.VERSIONOBJID
WHERE
HARVERSIONS.MAPPEDVERSION > '0'
GROUP BY
HARENVIRONMENT.ENVOBJID
) NONZEROVERSIONS ON HARENVIRONMENT.ENVOBJID
= NONZEROVERSIONS.ENVOBJID
WHERE
HARENVIRONMENT.ENVOBJID > 0
AND HARENVIRONMENT.ENVISACTIVE = 'Y'
ORDER BY
HARENVIRONMENT.ENVIRONMENTNAME
Feedback
