Could you clarify what you mean by "technical conditions".
Note that you cannot include all of the information you are after in a single report. Due to the way SQL works, this will lead to duplication.
- For software, you can use the built-in report "Software: List of software by computer", found under Dashboard/Reports/All Reports.
- For monitors, you can use the built-in report "Monitor: Information".
- For the rest of the information you are after, please use the report below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssets.Memory,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSName,
tblAssets.SP,
tblDiskdrives.Caption As Drive,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And tblAssetCustom.State =
1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
Drive
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.
