I searched the forum for sql query warranty expiry date and found this:-

 

 

SELECT resource.RESOURCENAME "Resource Name",LONGTODATE(resource.warrantyexpiry) "Warrenty ExpiryDate",productType.COMPONENTTYPENAME "Product Type" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID order by 3,2

 

The report query worked fine but i would like to know if anyone has any solution to my questions below:-

 

(1) Report search query return all resources. Is there a way to select only one resource - "Server"?

 

(2) LONGTODATE return date and 12:00AM timestamp. Is there a way to restrict display to date only?

 

(3) Report displayed all warranty expiry date. I would like to schedule a report search query weekly that will display resource which will expire in 30 days or less.

 

I would appreciate any feedback/solution. Thanks in advance for any suggestion and workaround.