i'm not sure. But you have default Aggregate data rules like:
- Fixed Drive Total Storage
- Logical Drive Total Available Storage
Doesn't work this rules for you?
Thank for your attention.
The 2 rules you mentioned work correctly.
But in my case, there are some LUNs attached to my managed devices and I don't want to calculate these attached storages in the sum (as I explained in the question).
It's a "conditional" Aggregate anyway.
Can you show how the LUN is being displayed? Is it in the same location as the rest? These rules can be very sensitive and if the LUN is reported differently it will be excluded.
MarXtar Ltd/MarXtar Corporation
LANDESK One Development Partner
Try MarXtar State Management for LANDESK to Better Understand and Manage your Assets
I created a calculation rule but it is not working with "One to many" attributes : it check for the first and not the next although I use a loop
My Calc rule:
For i=0 to 10
D=!Computer.Mass Storage.Fixed Drive.Disk Index!
C="!Computer.Mass Storage.Fixed Drive.Caption!"
Stg="!Computer.Mass Storage.Fixed Drive.Total Storage!"
If D=i AND Instr(C, "LUN")=0 then
CalcStg = CalcStg + Stg
RetValue = CalcStg
If the first drive is not a LUN, it returns the first drive storage but not the others fixed drive
If the first drive is a LUN, it's returns 0
I think you might need first to create a Map Data rule where it's easier to select which data to copy somewhere else. There you can exclude LUN's. On the copied data you can run the Calculate Rule.
I would create another column in your "Fixed Drive" table, let's call it "Total Storage by Fixed Drive" as an integer.
Then create a "Calculate Data" rule with the target "Computer.Mass Storage.Fixed Drive.Total Storage by Fixed Drive" and use the following calc:
retvalue = "!Computer.Mass Storage.Fixed Drive.Caption!"
if Instr(retvalue, "LUN") > 0 then
retvalue = 0
retvalue = !Computer.Mass Storage.Fixed Drive.Total Storage! / 10
After that, every Fixed Drive with the word "LUN" should have a value of "0", and the rest the true storage value.
Then create a new "Aggregate Data" rule and select as source your "Total Storage by Fixed Drive" field and as destination another new field like "Total Storage without LUN".
That should do the trick...
Thanks Christian, you did it !
My limited brain didn't consider to create a new field.
Great Job !
frank.wils : The map rule is too complicated in this case because of one to many attribute and a variable quantity of disk in the managed servers.