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

[ashley_420]

Thank you!!!

[Hemoco]

Sample Linux report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblLinuxSystem.OSRelease,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.Processor,
tblAssets.NrProcessors,
tblState.Statename As State,
tsysIPLocations.IPLocation,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblLinuxHardDisks.Filesystem,
tblLinuxHardDisks.Size,
tblLinuxHardDisks.Available,
tblLinuxHardDisks.Used,
tblLinuxHardDisks.Percentage,
tblLinuxHardDisks.MountedOn,
tblLinuxNetworkDetection.Name,
tblLinuxNetworkDetection.Mac,
tblLinuxNetworkDetection.Ipv4
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblLinuxHardDisks On tblAssets.AssetID = tblLinuxHardDisks.AssetID
Inner Join tblLinuxNetworkDetection On tblAssets.AssetID =
tblLinuxNetworkDetection.AssetID
Where tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1 And
tblLinuxNetworkDetection.Broadcast Is Not Null
Order By tblAssets.IPNumeric,
tblLinuxHardDisks.Filesystem

[ashley_420]

For Linux

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

[ashley_420]

How can I get similar report for non windows computers?

[Hemoco]

ashley_420 wrote:
How can I get similar report for non windows computers?

Could you clarify which specific asset types (Linux, Mac...) and fields you would like to include in your report?

[afinety]

Thank you. That report worked.

[afinety]

I work with Lansweeper at more than one location (both are running Lansweeper v5079). At one location this report (the last version above) works fine; at the other location it runs but produces no results.

Any ideas? Thanks.

[Hemoco]

afinety wrote:
I work with Lansweeper at more than one location (both are running Lansweeper v5079). At one location this report (the last version above) works fine; at the other location it runs but produces no results.

Please ensure that:
- Your Windows computers have been successfully scanned. Machines that haven't been successfully scanned are not included in the report.
- Your computers belong to at least one IP location. Machines that don't belong to any IP location are not included in the report. You can also use the SQL query below to include machines without an IP location.

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
Left 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]

This works well for Windows and Hyper-V guest.