Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1472

Re: Query doubt

Show all headers | View raw

contracer (contracer11@gmail.com) writes:
> Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs
> WITH (NOLOCK)
> INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID
> INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID
> where ccs.ErrorMessage LIKE '%atingiu%'
> order by 2 asc
> 
> I get:
> 
> SERVER1      FS /apl/orawpsp atingiu 90% de utilizacao -> 533 MB
> disponiveis -
>                  FS /bd1/orawppdata/sys atingiu 90% de utilizacao ->
> 199 MB disponiveis -
> 
> 
> How could I change this query to get output below:
> 
> SERVER1      FS /apl/orawpsp atingiu 90% de utilizacao -> 533 MB
> disponiveis -
> SERVER1  FS /bd1/orawppdata/sys atingiu 90% de utilizacao -> 199 MB
> disponiveis -
 
So does this query only return a single row, and ccs.errormessage has 
text with a line feed in it? That would be the only explanation for
the server name only being listed once. But I am not familiar with
your tables, so I might be missing something.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Query doubt contracer <contracer11@gmail.com> - 2013-05-08 18:33 -0700
  Re: Query doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-09 10:31 +0200
  Re: Query doubt rja.carnegie@gmail.com - 2013-05-09 13:56 -0700

csiph-web