Chart Reports- REG

[Sujitha_L_M]

Hi,

In new version of Lansweeper there are some additional Reports from which we noticed a report called "Chart: Computer Bios Age". By opening that report the count of the machines is displaying. But how we get the list of machines instead of count. Kindly check the attachment for further reference.

Thanks & Regards,
Sujitha L M

[Hemoco]

For a list you will need to create a separate report. A sample report can be seen below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
DatePart(yyyy, tblBIOS.ReleaseDate) As Year,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Order By DatePart(yyyy, tblBIOS.ReleaseDate),
tblAssets.AssetUnique

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run Report button to save it.
• The report will now also be listed under Dashboard\Reports\All Reports.