This post is more than 5 years old

1 Rookie

 • 

39 Posts

925

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?

117 Posts

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

117 Posts

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

1 Rookie

 • 

39 Posts

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='

117 Posts

November 7th, 2014 09:00

From the Avamar utility node (via SSH) as user admin.

Adam

Top