Deatiled Report for one Computer

[ashley_420]

Hi,

Is there a way I can view/create/export a detailed report for a single computer with the items scanned.

Thanks

[Hemoco · Accepted solution]

Try the report below instead.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.Processor,
tblState.Statename As State,
tsysIPLocations.IPLocation,
tblAssetCustom.Serialnumber As Serial,
tblAssets.Firstseen,
tblAssets.Username,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblDiskdrives.Caption As Drive,
tblDiskdrives.Volumename,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
FreeMB,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) -
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
UsedMB,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As TotalMB,
Floor(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
Else tblDiskdrives.Size End) * 100) As FreePCT,
Ceiling((tblDiskdrives.Size - tblDiskdrives.Freespace) /
(Case tblDiskdrives.Size When 0 Then 1 Else tblDiskdrives.Size
End) * 100) As UsedPCT,
tblAssets.IPAddress,
tblAssets.Mac,
tsysOS.Image As icon
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblState On tblState.State = tblAssetCustom.State
Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) Is Not
Null And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetUnique,
Drive

[ashley_420]

My apologies for delayed response. The above mentioned query throws the following error "Divide by zero error encountered"

[Hemoco]

All-in-one reports always are tricky since scanning methods and data storage depends on the asset type.
We could try to make several reports and then make a union of the reports for Windows, Linux, Mac, ...

Please give your feedback on the report below for windows.
Keep in mind that when you have multiple partitions, the number of lines in the report will be multiplied by that number.

Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Memory,
tblDiskdrives.Caption As Drive,
tblDiskdrives.Volumename,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As nvarchar) As [Disk size],
Cast(Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 /
1024 As numeric) As nvarchar) As [Free Space],
Cast(Floor(tblDiskdrives.Freespace / tblDiskdrives.Size * 100) As nvarchar(3))
+ ' %' As [Percent Free],
tblAssets.Processor,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber As Serial,
tsysIPLocations.IPLocation,
tblAssets.Username,
tblAssets.Firstseen,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblState.Statename,
tblAssets.IPAddress As [IP Address],
tblAssets.Mac
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblState On tblState.State = tblAssetCustom.State
Where Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 /
1024 As numeric) As nvarchar) Is Not Null And tblDiskdrives.FileSystem Is Not
Null
Order By tblAssets.AssetID

[ashley_420]

Thanks for your reply. Basically I am looking to get the information shown in the summary tab. The idea is to get this information and import in our Configuration Management system. It would be very nice to have this information for all computers (Windows/Linux/Hyper-v/VMWARE) in one report. The fields I am looking for is as below

Asset Type
OS
Manufacturer
Model
Memory
Processor
State
IP Location
Serial
First Seen
Username
Purchase Date
Disk Partition Information
- Name
- Size
- Available
- Space Used
- Space used in percentage
Network Information
- Name
- MAC
- ipv4

[Hemoco]

Could you clarify which specific data you are interested in. There are hundreds of computer fields within the Lansweeper database. You cannot include all of them in a single report.