
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-15-2014 08:09 AM
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
- 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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2014 03:53 PM
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
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2014 03:53 PM
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
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
