Mass Inventory Report

[adeleon31]

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

[Ben_V · Accepted solution]

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.%'