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?