Two reports suitable for notifying the administrators about incoming events are a part of the ALVAO Asset Management product.
The Objects with nearing due date report (Expiring objects csy.rdl, Expiring objects enu.rdl) allows to set a notification of any date in the object properties according to the defined advance (number of days in the future).
The Licenses with nearing due date report (Expiring licenses csy.rdl, Expiring licenses enu.rdl) allows to set a notification of the validity or support date for a license.

Note:

Reports are in Czech and English only.

Installation

RDL files can be found on the www.alvao.com/download site under Asset Management product in the MaintenanceReports.zip archive.
The description of how to install reports can be found on the Installing Reports in Microsoft SQL Server Reporting Services site.

Objects with Nearing Due Date

The report is suitable for notifying about the incoming events/scheduled maintenances in the asset registry.
There is a need to register a property containing any future date for required devices. This date may designate for example end of warranty, next check date, next replacement of UPS battery date etc.
The report with all objects having this date in their entered advance is then generated according to this date and the entered advance in order to give the technician enough time to respond on an event.

Parameters

Organizational part – enter a path to the folder in the tree you want to generate the report for. If you enter nothing, the report will be generated for whole registry.
Object kind – from the menu select one or several kinds of objects you want to show in the report.
Property – from the menu select the property which the scheduled due date is in.

Note:
Only a date type property can be selected.
Filter – enter a custom condition for filtering the objects by the values of any property in the SQL condition form.
Example: „([Manufacturer] = ‘EPSON‘ OR [Manufacturer] LIKE ‘Gigabyte%‘) AND [Vendor] LIKE ‘Softcom%’”.
Advance (days) – enter how many days before due date may the objects show in the report.

Licenses with Nearing Due Date

The report serves to notify about expiring licenses and ending maintenance of licenses.
Licenses are selected according to the entered advance.

Parameters

Date – select the date you are interested in the report – "Valid to" or "Upgrade/Support to".
Filter – enter custom condition for filtering the licenses by the manufacturer in the SQL condition form.
Example: „[Manufacturer] LIKE ‘Microsoft %‘ OR [Manufacturer] = ‘ALVAO s.r.o.‘”.
Advance (days) – enter how many days before deadline may the licenses show in the report.

Did not find what you were looking for? Ask our technical support team.