→ 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: 
adeleon31
Engaged Sweeper
Hello,

I would like to create a report which has the following field if possible:

Domain
Manufacturer
REPLACE (CS.Manufacturer0, 'System manufacturer', 'Assembled') AS Manufacturer0,
REPLACE (CS.Model0 , 'System Product Name' , 'Assembled')AS Model0, (This is for any assembled machines that may not be discovered)
IP address
CPU Name/ Model
RAM total physical memory
Hard-drive Size
Operating system


Include a Where
WHERE
IP.IP_Addresses0 LIKE 'xxx.xxx.%'

Basically I am in need of creating a report which returns all Windows machines that gives me the model of the machine, operating system version, Total RAM, Total HD Space, and domain. Only want to see Windows mahcines (No monitors, VDI, Printers, etc)


Any help would be appreciated

1 ACCEPTED SOLUTION
Ben_V
Lansweeper Alumni
Hi,

The following report will show information about all the Windows assets which are active. The where clause is optional and can be deleted.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename as [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblProcessor.Caption As [Processor Model],
tblProcessor.Name As [Processor Name],
cast(tblAssets.Memory as varchar) +' Mb' as [Memory],
Cast(Cast(tblFloppy.Size As bigint) / 1024 / 1024 / 1024 As varchar) + ' Gb' As [HDD Size],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
inner join tblFloppy on tblAssets.AssetID = tblFloppy.AssetID
inner join tblOperatingsystem on tblAssets.AssetID = tblOperatingsystem.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1 and tblAssets.IPAddress like '%192.168.1.%'

View solution in original post

1 REPLY 1
Ben_V
Lansweeper Alumni
Hi,

The following report will show information about all the Windows assets which are active. The where clause is optional and can be deleted.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename as [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblProcessor.Caption As [Processor Model],
tblProcessor.Name As [Processor Name],
cast(tblAssets.Memory as varchar) +' Mb' as [Memory],
Cast(Cast(tblFloppy.Size As bigint) / 1024 / 1024 / 1024 As varchar) + ' Gb' As [HDD Size],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
inner join tblFloppy on tblAssets.AssetID = tblFloppy.AssetID
inner join tblOperatingsystem on tblAssets.AssetID = tblOperatingsystem.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1 and tblAssets.IPAddress like '%192.168.1.%'