How do I calculate the difference in days between the current date and the expiry date of a license via a rule?

The following how-to guide, will walk you through how to make use of the Geneos rule engine as well as the toolkit sampler in order to display the data.

1 ? Create Simple Script to run on the Toolkit Plugin

The following script can be used as an example:

#!/bin/bash
echo “license, expiry, days”
echo “prod, 2018-jun-20, ,”

The column ?expiry? would need to be altered to suit the end date of your license, in order for this to work correctly on your system. The script is located under /home/hbatista/scripts/dayDiff.sh

NOTE: Date format for expiry should be as follows: YYYY-Jan-DD

The toolkit sampler should look like the following with the path of the dayDiff.sh included

Going over to the dataview, it should look like the following:

2 ? Creating the Rule

The below XML can be used as an example,

 


<rule name="daysDiff">
    <targets>
        <target>/geneos/gateway[(@name=&quot;TestGateway&quot;)]/directory/probe[(@name=&quot;Cluster Monitoring Probe&quot;)]/managedEntity[(@name=&quot;Toolkit_ME_Test&quot;)]/sampler[(@name=&quot;License Day Difference&quot;)][(@type=&quot;&quot;)]/dataview[(@name=&quot;License Day Difference&quot;)]/rows/row[(@name=&quot;prod&quot;)]/cell[(@column=&quot;days&quot;)]</target>
    </targets>
    <priority>1</priority>
    <pathAliases>
        <pathAlias name="exp">../cell[(@column=&quot;expiry&quot;)]</pathAlias>
    </pathAliases>
    <block>
        <transaction>
            <update>
                <property>@value</property>
                <format>
                    <string>%.0f Days</string>
                    <divide>
                        <subtract>
                            <parseDate>
                                <string>%Y-%b-%d</string>
                                <dataItem>
                                    <pathAlias ref="exp"></pathAlias>
                                    <property>@value</property>
                                </dataItem>
                            </parseDate>
                            <now></now>
                        </subtract>
                        <integer>86400</integer>
                    </divide>
                </format>
            </update>
        </transaction>
    </block>
</rule>

Note that the following changes would need to be amended on your machine in order to configure it correctly:

Target path - pointing to the ?days? column in the dataview
Path Alias (under Advance tab) ? using the Path Editor copy & paste the path of the ?days? column in the toolkit dataview under the section ?Evaluate path relative to? within the Path Editor, in order to evaluate the path

This path will be used in order to calculate and fill the toolkit with the number of days remaining, based on the date entered in ?expiry? as seen below:

Articles in this section

How do I calculate the difference in days between the current date and the expiry date of a license via a rule?

Comments

Articles in this section

Related articles