SQL Query to check HOSTNAME

Several scripts
Post Reply
User avatar
rchkevin
Nouveau
Nouveau
Posts: 67
Joined: 29 Oct 2007 12:00
Location: Chennai

SQL Query to check HOSTNAME

Post by rchkevin » 22 Oct 2009 8:42

What is the SQL Query to check the hostname in the DB

User avatar
YOWAL
Nouveau
Nouveau
Posts: 18
Joined: 07 Jan 2009 12:00
Location: Argentina, Buenos Aires

Re: SQL Query to check HOSTNAME

Post by YOWAL » 22 Oct 2009 1:51

rchkevin wrote:What is the SQL Query to check the hostname in the DB
HI

FOR EM
Select NODE_ID FROM DEF_JOB;

FOR CMS
Select NODEID FROM CMR_AJF;

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 22 Oct 2009 2:02

wich kind of hostname ?

regards
philmalmaison

User avatar
rchkevin
Nouveau
Nouveau
Posts: 67
Joined: 29 Oct 2007 12:00
Location: Chennai

Post by rchkevin » 22 Oct 2009 7:03

Hostname of EM and CTM SERVER

User avatar
himanshu
Nouveau
Nouveau
Posts: 26
Joined: 25 Nov 2008 12:00
Location: India
Contact:

Post by himanshu » 22 Oct 2009 7:07

SQL> sqlplus svctme64@ecspcor6

Enter password

SQL> select count(*) from commreg where CTLMACHINE='ctmdvsx103e'; <or> delete commreg where CTLMACHINE='ctmdvsx103e'; <or> commit;

User avatar
alexcamron
Nouveau
Nouveau
Posts: 3
Joined: 27 May 2011 12:00

Post by alexcamron » 27 May 2011 9:20

Hello friends I am college student and also Networking student. I'll create a website and I have a c-penal but have no idea about SQL DB. I want sms website but I am just understand HTML script. I am create sms website but it's not work for me because I am not set SQL so if you have tutorial or idea about this so please help me.
thanks in advance.

Post Reply