Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Does anyone knows how you can find out the servername using a select query ? I can't find any table containg it....
select server_name from servers
The status table contains the server name.
Does anyone knows how you can find out the servername using a select query ? I can't find any table containg it....
This sounds odd. There should only be 1 row in the status table.Actually
>select server_name from status
getting many lines because there is one status for every node so output will like
tsm_inst1
tsm_inst1
tsm_inst1
tsm_inst1
tsm_inst1
tsm_inst1
tsm_inst1
etc depending how many nodes are there ....
so correct one is
SELECT distinct(server_name) from status
and answer will be
SERVER_NAME
---------------------------------------------------------------------------------------------------------------------------------
tsm_inst1
Protect: SERVER1>select count(*) from status
Unnamed[1]
------------
1