→ 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: 
shiryunaga
Engaged Sweeper
Hi, I need to create a custom report on LANSweeper

- Assetname
- Username
- SerialNumber
- Processor

- Memory DeviceLocator (DIMM1 etc) optional
- Memory Capacity
- Memory Speed

- Diskdrive Name (PHYSICALDRIVE0 etc) (optional)
- Diskdrive InterfaceType
- Diskdrive Size

- Network Description
- Network MacAddress
- Network DHCP (True)

example i have pc with 2 memory 1GB/2GB and 2 harddrive 1TB/2TB

report
DIMM1 1024MB 1066
DIMM2 2048MB 800

PHYSICALDRIVE0 IDE 1000GB
PHYSICALDRIVE1 SATA 2000GB

Wireless xx:xx:xx:xx:xx:xx True
Gigabit xx:xx:xx:xx:xx:xx True


thank






1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
It is possible to put these fields in one report but then you will get too many duplicate rows. Therefore we have created three reports for you:

The will give you all memory information:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblPhysicalMemory.DeviceLocator,
tblPhysicalMemory.Capacity,
tblPhysicalMemory.Speed
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID

The second report will give information about the hard disks:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblFloppy.Name,
tblFloppy.InterfaceType,
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID

The third report will give you all network interfaces:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblNetwork.Description,
tblNetwork.MACaddress,
tblNetwork.DHCPenabled
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
It is possible to put these fields in one report but then you will get too many duplicate rows. Therefore we have created three reports for you:

The will give you all memory information:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblPhysicalMemory.DeviceLocator,
tblPhysicalMemory.Capacity,
tblPhysicalMemory.Speed
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID

The second report will give information about the hard disks:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblFloppy.Name,
tblFloppy.InterfaceType,
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID

The third report will give you all network interfaces:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblNetwork.Description,
tblNetwork.MACaddress,
tblNetwork.DHCPenabled
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID