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.....