I need to design a group availability report which should not include maintenance period for calculating avaialbility. Is this possible?
I would imagine it should be possible via custom queris but don't know how.
Any help?
basically you will need to run a sql query for this and calculate your own availability based on that time frame, due to the availability on NPM being simply if it is not up then it is not available. I make this distinction because even if the node is placed in unmanaged state it is considered down for that time and therefore unavailable.
Is there any document which provides guidance for customised query?