→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tyuma
Engaged Sweeper
Hi,

I love Lansweeper but the reporting could definitely be more user friendly. I've been trying to figure out how to create a basic report including:

PC Name
OS
OS version
HD size (in MB/GB)
RAM size (in MB/GB)
Processor type/speed
Make/model of the PC
Serial # of the PC
MS Office version

Any help would be much appreciated. In the meantime, is there a tutorial or "how to" for creating basic reports? Also, are there any "canned" or template reports available?

Thanks!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Building reports requires SQL knowledge, as the Lansweeper report builder uses standard SQL queries. We recommend familiarizing yourself with SQL: http://www.w3schools.com/sql/default.asp

For the specific information you are after, please use the report below. Note that there are hundreds of built-in reports under Dashboard/Reports/All Reports.
Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.OScode,
tblAssets.SP,
tblOperatingsystem.Caption As FullOSName,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Memory,
tblAssets.Processor,
tblProcessor.MaxClockSpeed,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like 'Microsoft%Office%20%' And
tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]

View solution in original post

2 REPLIES 2
tyuma
Engaged Sweeper
Thank you very much for your reply. I really appreciate it.
Hemoco
Lansweeper Alumni
Building reports requires SQL knowledge, as the Lansweeper report builder uses standard SQL queries. We recommend familiarizing yourself with SQL: http://www.w3schools.com/sql/default.asp

For the specific information you are after, please use the report below. Note that there are hundreds of built-in reports under Dashboard/Reports/All Reports.
Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.OScode,
tblAssets.SP,
tblOperatingsystem.Caption As FullOSName,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Memory,
tblAssets.Processor,
tblProcessor.MaxClockSpeed,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like 'Microsoft%Office%20%' And
tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]