I Need to create a History file system Report

I Need to create a History file system Report

Hi it's possible to create a month report with the following output ?

ID: Server or device
Element: File System or partition
date: Date
range: [min value - Max Value]
current val: Value for the monitor date

I have to build a Query using polleddate table or statsdata_daily table but it does not work for me

i have this query:

SELECT POLLID,instance,from_unixtime(ttime/1000) as Tiempo,VAL,MINVALUE,MAXVALUE, tinterval FROM OpManagerDB.statsdata_daily s where ttime >= unix_timestamp('2008-01-01 00:00:00')*1000 order by ttime;

i don't Know the field POLLID

and this:
select name,agent,from_unixtime(LASTTIMEVALUE/1000),from_unixtime(TIMEVAL/1000),POLICYNAME,FAILURETHRESHOLD from OpManagerDB.polleddata order by agent,name;

the second Query don't display the values for every item.

Any Idea?

Thanks & Regards.
ENZO. :cry:























                  New to ADSelfService Plus?