Want to Know What Assets Are Under Warranty?

I recently received request for a report that would show which of our computers are covered by a warranty. I looked around and didn't see a report off hand (that was not tied to the expiration of the warranty) but I did see a lot of similar reports for expiring leases.

Hopefully my solution to this reporting problem will come in handy for someone else.

My Solution

Change the attached txt file to xml to import into NS.

This report first shows all warranties. Choose a warranty and right click for a drill down to show the active computers that are covered by the warranty.

While I just list the warranty and the computer, to see all the associated fields available, add a * to see all the rows of data that are available.

Here are the two sql queries:

level 0:
Select * from vWarranty

level 1:
Select vw.name as [Warranty Name], vc.name as [Asset Name] from vwarranty vw inner join inv_covered_hardware ch on vw._resourceguid = ch._resourceguid  
left outer Join dbo.Inv_AeX_HW_Serial_Number sn on ch.[serial number] = sn.[serial number]  
left outer join vcomputer vc on vc.guid = sn._resourceguid  
where vw._resourceguid = %_ResourceGuid%

Then add a drilldown on Level 0 for the resource guid. See screenshot.

Click to view.