
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-22-2013 06:03 PM
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.
Labels:
- Labels:
-
General Discussion
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-28-2013 05:15 PM
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.
