
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-01-2015 10:09 AM
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
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
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
‎01-02-2015 01:30 PM
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
http://www.lansweeper.com/Forum/yaf_postst10408_Connected-monitors.aspx#post39180
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2015 01:30 PM
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
http://www.lansweeper.com/Forum/yaf_postst10408_Connected-monitors.aspx#post39180
