[ADSM-L] Script question

Hi All

Need a little help with this script

select cast(node_name as varchar(20)) as "Nodebane" , cast(TCP_ADDRESS as 
varchar(15)) as "IP" ,  cast(CLIENT_OS_NAME as varchar(35)) as " OS Name"   , 
cast(CLIENT_SYSTEM_ARCHITECTURE as varchar(4)) as "BIT" , 
cast(APPLICATION_VERSION as varchar(2)) as "Aooplcation Version", 
cast(APPLICATION_RELEASE as varchar(2)) as "Applcation Release", 
cast(APPLICATION_LEVEL as varchar(2)) as "Application Level" , 
cast(APPLICATION_SUBLEVEL as varchar(2)) as "Application Sublevel" from nodes  
where (node_name like ('%%_DB')  and node_name not like ('DRM%%')) order by 4

Got output:

Nodenane                                IP                                      
     OS Name                                                     BIT          
Application Version      Application Release      Application Level      
Application Sublevel
---------------------     ----------------     
------------------------------------                                          
-----       --------------------            -------------------             
------------------           ---------------------
HPLDB                                  132.74.1.210                            
AIX:AIX                                                          PPC
EXCHSRVAN_DB              132.74.1.226                            WIN:Windows 
Server 2008 R2              x64        7                                        
     1                                             4                            
        0
EXCHSRVBN_DB              132.74.1.227                             WIN:Windows 
Server 2008 R2              x64        7                                        
     1                                             4                            
        0

Why the line:    HPLDB appears !!

I specific node_name like(‘%%_DB’)   ?????

Ideas ???

Best Regards

Robert


[cid:[email protected]]<http://computing.haifa.ac.il/>

רוברט אוזן
ראש תחום שרידות וזמינות נתונים.
אוניברסיטת חיפה
משרד: בניין ראשי, חדר 5015
טלפון:  04-8240345 (פנימי: 2345)
דואר: rouzen AT univ.haifa.ac DOT il
_____________________________________________________
אוניברסיטת חיפה | שד' אבא חושי 199 | הר הכרמל, חיפה | מיקוד: 3498838
אתר אגף מחשוב ומערכות מידע: 
http://computing.haifa.ac.il<http://computing.haifa.ac.il/>