Inventory report custom

[laurentiun]

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)

[RCorbeil]

Depending on your exact output needs, you might find this thread useful.

[Esben_D]

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.