cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
khaleehh
Engaged Sweeper II
Hey , i was tring all mentioned ways to merge computer with two monitors , but still i cannot do it :

Select Top 1000000 tblAssets.AssetID,
tblAssetCustom.Custom5 As [Employee Name],
tblAssets.AssetName As [Computer Name],
tblAssetCustom.Custom3 As [SAP Asset Code],
tblAssetCustom.Serialnumber,
tblAssetCustom.Custom4 As Type,
tblAssetCustom.Model,
tblAssets.Processor,
Convert(DECIMAL(9,0),tblAssets.Memory / 1024) As Memory,
Convert(DECIMAL(9,0),Sum(tblDiskdrives.Size) / 1024 / 1024 / 1024) As HDD,
tblMonitor.SerialNumber As [Serial Number],
tblSerialnumber.Product As OS,
tblSerialnumber.ProductKey As [OS Key]
From tblAssets
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblMonitor On tblAssets.AssetID = tblMonitor.AssetID
Where tblSerialnumber.Product Like '%windows%'
Group By tblAssets.AssetID,
tblAssetCustom.Custom5,
tblAssets.AssetName,
tblAssetCustom.Custom3,
tblAssetCustom.Serialnumber,
tblAssetCustom.Custom4,
tblAssetCustom.Model,
tblAssets.Processor,
Convert(DECIMAL(9,0),tblAssets.Memory / 1024),
tblMonitor.SerialNumber,
tblSerialnumber.Product,
tblSerialnumber.ProductKey

1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
You can find a report in the report center which lists you all monitors for each computer in one row:
http://www.lansweeper.com/Forum/yaf_postst10408_Connected-monitors.aspx#post39180

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
You can find a report in the report center which lists you all monitors for each computer in one row:
http://www.lansweeper.com/Forum/yaf_postst10408_Connected-monitors.aspx#post39180