cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
joekos
Engaged Sweeper
One of the widgets on the hardware tab is the Computer Chassis Overview. When you click on one of these items you get a listing of all of that class of chassis. Is there a way to add the Model of each of these items in the report? For example I clicked on the Notebook link and it lists all of our computers classified as such, but it doesn't list the model name for each of these. I can just dump to a spreadsheet and do some matching there but if it's easier to add the model to this report than using excel i'd rather do that.
1 REPLY 1
Hemoco
Lansweeper Alumni
joekos wrote:
Is there a way to add the Model of each of these items

No, we do not support making changes to the widget. You can use a custom report to list the information you are after:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname,
tblAssets.SP,
tblAssets.Memory,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblAssets.Processor,
TsysChassisTypes.ChassisName,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblAssetCustom.State = 1
Order By TsysChassisTypes.ChassisName,
tblAssets.Domain,
tblAssets.AssetName

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. Export options are listed on the left.
• The report will now also be listed under Dashboard/Reports/All Reports.