G
Guest
Hi,
I am trying to code a spdsht that can be used to monitor diskspace across
multiple servers and logical drives per server.
The data acquisition is complete and i have no problems automating the
collection of the data using a wmi script and feeding it into excel and
generated basic time vs diskspace charts.
What i want to create is a simple dashboard style chart that will show any
logical drive that is below a certain threshold to provide a clear visual
warning to the operator.
At the moment I have a simple min() function using if() to remove servers
whose free space is great than 50%. however .... if a server recovers space
the chart will still only show the min() value.
How can I use a lookup function to generate this chart only for the current
days data set (Did i mention that the spdsht is archived once a month?) so
that.
I have so far been unsucessful in creating this.
my data set looks something like this...
//server/drive,1-jan,2-jan,3-jan,
//svr1/c,65,63,40,38,
//sv1/d,80,80,80,80,
//svr2/c,20,15,5,60,
As you can see ... if i use min() then for //svr2/c it will only ever report
as 5% free even though the following day diskspace increased to 60%
Any help greatfully accepted.
G.
I am trying to code a spdsht that can be used to monitor diskspace across
multiple servers and logical drives per server.
The data acquisition is complete and i have no problems automating the
collection of the data using a wmi script and feeding it into excel and
generated basic time vs diskspace charts.
What i want to create is a simple dashboard style chart that will show any
logical drive that is below a certain threshold to provide a clear visual
warning to the operator.
At the moment I have a simple min() function using if() to remove servers
whose free space is great than 50%. however .... if a server recovers space
the chart will still only show the min() value.
How can I use a lookup function to generate this chart only for the current
days data set (Did i mention that the spdsht is archived once a month?) so
that.
I have so far been unsucessful in creating this.
my data set looks something like this...
//server/drive,1-jan,2-jan,3-jan,
//svr1/c,65,63,40,38,
//sv1/d,80,80,80,80,
//svr2/c,20,15,5,60,
As you can see ... if i use min() then for //svr2/c it will only ever report
as 5% free even though the following day diskspace increased to 60%
Any help greatfully accepted.
G.