→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
laurentiun
Engaged Sweeper III
Hello,

I'm trying to build a report.. but I have some issues like double rows for computers with two monitors or two Microsoft Office versions. I would like to create a new column for second monitor and second Microsoft Office software, also in my report not all computers are showing. Also, computers without antivirus are not shown at all..

AssetName
AssetTypename
Username
Domain
Processor
Memory
Manufacturer
Assetname
IPAddress
Model
DisplayName
onAccessScanningEnabled (antivirus)
productUpToDate (antivirus)
InstallDate
Product (Windows)
ProductID
WindowsProductKey
OSname
softwareVersion (Microsoft Office)
Software (Microsoft Office)
MonitorModel
SerialNumber (monitor)
MonitorModel 2
SerialNumber (monitor 2)
2 REPLIES 2
RCorbeil
Honored Sweeper II
Depending on your exact output needs, you might find this thread useful.
Esben_D
Lansweeper Employee
Lansweeper Employee
If an asset has multiple monitors connected to it the only way to get it in different columns would be to use subqueries to show each monitor in a column. Otherwise duplicate rows are inevitable.

I would also recommend sharing what you have now, others will help quicker when they have something to start with instead of writing the whole query from scratch.