Computer Build Report

[Arron]

Hello,

I am not sure if this is possible due to the way the data is in the DB, but i am looking for a report that will help with replacing computers. The plan is to filter on computer name and it show in 1 list: Map network drives + lettters, Printers and list of installed Software.

I have a start with the below but it shows duplicate data per network drive.

Select Top 2000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username As Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblmappeddrives.Driveletter,
tblmappeddrives.RemotePath,
tblmappeddrives.Username As [Map Drive Username],
tblAssets.Lastseen,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tblPrinters.Caption,
tblPrinters.Portname,
tblPrinters.Location
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblmappeddrives On tblAssets.AssetID = tblmappeddrives.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Order By tblAssets.AssetName

[Esben_D]

Depending on the data you select you will indeed almost identical rows. For example, if an asset has multiple network drives, and you choose to display the drive letter. It is logical that there will be multiple rows, one for every drive letter.

Similar thing goes for the printer caption, if you have 5 local printers installed, it adds an additional 5 rows. Which would total out in 5 rows per drive letter. You can see how this can add up pretty fast.

The easiest way to prevent this is creating separate reports, one for drives, one for printers and one for software.