cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jorge
Engaged Sweeper
Is it possible to create a unique report about devices and computers warranty?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
A sample report that includes both computer and device warranty information can be seen below. Note that, in Lansweeper 4.2, warranty information must be submitted manually. Lansweeper 5.0 automatically scans warranty information for a number of brands. Lansweeper 5.0 is currently in beta. A download link and more info on the beta can be found here: http://lansweeper.com/forum/yaf_postst6619_Lansweeper-5-0-beta.aspx
Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.Lastseen, DERIVEDTBL.computername, DERIVEDTBL.PurchaseDate, DERIVEDTBL.Warrantydate From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain, tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Order By DERIVEDTBL.IPNumeric

To use the specified (4.2) report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
A sample report that includes both computer and device warranty information can be seen below. Note that, in Lansweeper 4.2, warranty information must be submitted manually. Lansweeper 5.0 automatically scans warranty information for a number of brands. Lansweeper 5.0 is currently in beta. A download link and more info on the beta can be found here: http://lansweeper.com/forum/yaf_postst6619_Lansweeper-5-0-beta.aspx
Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.Lastseen, DERIVEDTBL.computername, DERIVEDTBL.PurchaseDate, DERIVEDTBL.Warrantydate From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain, tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Order By DERIVEDTBL.IPNumeric

To use the specified (4.2) report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.