0 Replies Latest reply: Jun 28, 2012 1:43 AM by dheeraj NameToUpdate RSS

How to get data to get PING,tablespaces,& others using SQL query in BMC portal 2.8

dheeraj NameToUpdate

Hi Friends,

 

Here in example , this is a Linux OS which is productionserver , which also have parameters added like ping, oracle(table spaces), system memory and others..

 

Now, I want a select query which will get data of ping,oracle table spaces(all), memory from servername  where date = ‘1/10/2011’ to ‘31/10/2011’

 

 

 

     Date                                           ping      tablespace001    tablespace002 ..........             Memory

 

 

 

1/10/2011 9:05                               1                  87                              65                                               1300

 

1/10/2011 9:10                               1                  86                              67                                               1307

 

1/10/2011 9:15                              1                  87                              65                                               1300

 

1/10/2011 9:20                               0                  81                              67                                                1370

 

...

 

...

 

..

 

..

 

31/10/2011 9:20                              1                  91                              57                                               1070

 

 

 

Can you please help us, how to get this information using SQL queries of different servers &parameters.....