custom report for memory, hard drive, mac address

[shiryunaga]

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

[Hemoco · Accepted solution]

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