How to locate all UDP scripts

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

How to find all the UDP scripts as part of moving the Harvest Broker

Environment

Harvest 13.x and 14.x

Resolution

To get a listing of all the UDP scripts in the Harvest repository, the following query will list both stand-alone UDPs and pre/post link UDPs, what project and state they are in, and for pre/post link, what the parent process is:

 SELECT

  HARENVIRONMENT.ENVIRONMENTNAME,

  HARENVIRONMENT.ENVISACTIVE,

  HARSTATE.STATENAME,

  HARSTATE.STATEORDER,

  '' AS PARENTPROCESS,

  '' AS PROCESSPRELINK,

  HARSTATEPROCESS.PROCESSNAME,

  HARUDP.PROGRAMNAME,

  HARUDP.UDPTYPE

FROM HARENVIRONMENT

INNER JOIN HARSTATE ON HARENVIRONMENT.ENVOBJID = HARSTATE.ENVOBJID

INNER JOIN HARSTATEPROCESS ON HARSTATE.STATEOBJID = HARSTATEPROCESS.STATEOBJID

INNER JOIN HARUDP ON HARSTATEPROCESS.PROCESSOBJID = HARUDP.PROCESSOBJID

           AND HARSTATEPROCESS.STATEOBJID = HARUDP.STATEOBJID

UNION SELECT

  HARENVIRONMENT.ENVIRONMENTNAME,

  HARENVIRONMENT.ENVISACTIVE,

  HARSTATE.STATENAME,

  HARSTATE.STATEORDER,

  HARSTATEPROCESS.PROCESSNAME AS PARENTPROCESS,

  HARLINKEDPROCESS.PROCESSPRELINK,

  HARUDP.PROCESSNAME,

  HARUDP.PROGRAMNAME,

  HARUDP.UDPTYPE

FROM HARENVIRONMENT

INNER JOIN HARSTATE ON HARENVIRONMENT.ENVOBJID = HARSTATE.ENVOBJID

INNER JOIN HARSTATEPROCESS ON HARSTATE.STATEOBJID = HARSTATEPROCESS.STATEOBJID

INNER JOIN HARLINKEDPROCESS ON HARSTATEPROCESS.STATEOBJID = HARLINKEDPROCESS.STATEOBJID

           AND HARSTATEPROCESS.PROCESSOBJID = HARLINKEDPROCESS.PARENTPROCOBJID

INNER JOIN HARUDP ON HARLINKEDPROCESS.PROCESSOBJID = HARUDP.PROCESSOBJID

           AND HARLINKEDPROCESS.PARENTPROCOBJID = HARUDP.PARENTPROCOBJID

 

To search for a specific UDP script on a Linux or Unix server, this command would accomplish it:

find / -name the_name_of_a_udp 2>/dev/null

(replace “the_name_of_a_udp” with the name of the UDP script you’re looking for)

To search for a specific UDP script on a Windows server, this command would accomplish it:

dir /b/s C:\the_name_of_a_udp

(replace “the_name_of_a_udp” with the name of the UDP script you’re looking for)