‎find dataset a client uses via cli | DELL Technologies

Start a discussion

djr011

updated

12 years ago

Solved!

djr011

1 Rookie

•

39 Posts

1

942

November 4th, 2014 12:00

find dataset a client uses via cli

is there a way to list the datasets a particular client uses via a cli command?

C
clevya
117 Posts
641
0
Posted November 5th, 2014 04:00
Actually this will likely work better:

psql -p 5555 mcdb -U admin -c "select group_name, client_name, dataset_name from v_group_members where client_name='CLIENT_NAME';"

Regards,

Adam
C
clevya
117 Posts
641
0
Posted November 5th, 2014 04:00
Hi,

This should work:

psql -p 5555 mcdb -c "select group_name, client_name, dataset_name from v_group_members where client_name='CLIENT_NAME';"

Regards,

Adam
D
djr011
1 Rookie
•
39 Posts
641
0
Posted November 7th, 2014 07:00
where is this command ran from?

psql -p 5555 mcdb -c "select group_name, client_name, dataset_name from v_group_members where client_name='
C
clevya
117 Posts
641
0
Posted November 7th, 2014 09:00
From the Avamar utility node (via SSH) as user admin.

Adam