How can I get the full /path/project list?

[Ultramundane]

It looks like UV.account stores this info. I can see the projects and paths when I do a strings on this file. Is there any other place that is more readable to get this information? Is there a command that can be run to get this information? I can run dsjob -lprojects, but this only lists the projects. I tried to use dsjob -projectinfo <project name>, but this too only lists the name of the project and not the path.

Thanks.

[kcbland]

DS.TOOLS from any project TCL prompt will get you this information. Do you want programmatic access? If so, READ it out of UV.ACCOUNT and parse, or use the DSExecute API to execute the TCL command to SELECT the file. You can always use the unix command line read to access the file from a shell script.

[ray.wurlod]

Code: Select all

cd $DSHOME && . ./dsenv && bin/uv "SELECT @ID, PATH FMT '60L' FROM UV.ACCOUNT WHERE @ID NOT IN ('UV', 'uv') AND @ID NOT LIKE 'HS.%';" > /tmp/projects

Modify the WHERE clause to suit your requirements.

[Ultramundane]

Thanks. I had to change uv to uvsh because of load errors. But that works awesome.

Thanks.

[ray.wurlod]

Maybe dssh would be better than uvsh, even though they're presently the same executable.

[Ultramundane]

With your help Ray I ended up with the following code to get the projects.

Code: Select all

#!/bin/ksh

## SOURCE ENVIRONMENT
. ~/.dsadm

## CHANGE TO Directory Containing the VOC
cd $DSHOME

## GET PROJECT LIST INTO ARRAY
set -A MY_ARRAY $(dssh "SELECT PATH FMT '60L' \
        FROM UV.ACCOUNT \
       WHERE @ID NOT IN ('UV', 'uv', 'DS', 'ds') \
         AND @ID NOT LIKE 'HS.%';" \
| awk '{print $1}' \
| grep '/')

## LOOP COUNTER
typeset -i COUNT=0

## SIZE OF ARRAY
typeset -i ARRCNT=${#MY_ARRAY[*]}

## DISPLAY ARRAY ELEMENTS
while (( $COUNT < $ARRCNT ))
do 
   print "${MY_ARRAY[${COUNT}]}"

   (( COUNT = $COUNT + 1 )) 
done

exit 0

[ray.wurlod]

Did you mean

Code: Select all

## SOURCE ENVIRONMENT 
. ~/.dsadm
. $DSHOME/dsenv 

or does your dsadm script execute dsenv?

[Ultramundane]

My .dsadm environment file sources dsenv.

Thanks.

[ray.wurlod]

Welcome aboard. :D

Not dssh.exe on UNIX, just plain dssh - and you probably want to specify exactly the fields from UV_SCHEMA (or UV_ACCOUNT) that you want in the output - for example, you are probably not interested in the numeric ID of the owner or creator.

I prefer to give SQL syntax, even though I am fully aware that there is another query language available, because most folks are more familiar with SQL.

[kumar_s]

The same will be displayed in adminstrator client.
If you select a project from Projects tab, bottom of the client will show you the Project pathname.