Two reports suitable for notifying the administrators about incoming events are a part of the ALVAO Asset Management product.
Objects with nearing due date report (Expiring objects.rdl) allows to set the notification on any date in the object properties according to the defined advance (number of days in the future).
Licenses with nearing due date report (Expiring licenses.rdl) allows to set the notification on the validity or support date for 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.
Reports installation description 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.
Date (property value) can be written in the following formats (spaces in front of and behind separators are permitted):
- dd/mm/yyyy
- yyyy/dd/mm
- dd-mm-yyyy
- yyyy-dd-mm
- dd.mm.yyyy, d.m.yyyy
- yyyy.dd.mm, yyyy.d.m
Filter – enter 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.