Report for trendmicro instaleld assets

[danielideho]

Hello everyone,

I want to create a report a report for my assets that specifically have Trendmicro have installed. Till now I can not seem to figure this out, There is a report for windows defender but I can't seem to edit this one properly.

[ErikT]

Hi @danielideho 

The sample report below will get you the results you are after. Feel free to edit how you see fit.

Select Top 1000000

  tblAssets.AssetID,

  tblAssets.AssetName,

  tblAssets.Domain,

  tblAssets.Username,

  tblAssets.Userdomain,

  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,

  tblAssets.IPAddress,

  tsysIPLocations.IPLocation,

  tblAssetCustom.Manufacturer,

  tblAssetCustom.Model,

  tsysOS.OSname As OS,

  tblAssets.SP,

  tblAssets.Lastseen,

  tblAssets.Lasttried,

  tblSoftwareUni.softwareName As Software,

  tblSoftware.softwareVersion As Version

From tblAssets

Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID

Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID

Inner Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID

Left Join tsysOS On tblAssets.OScode = tsysOS.OScode

Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType

Where tblSoftwareUni.softwareName Like '%Trend Micro%'

  And tblAssetCustom.State = 1

Order By tblAssets.AssetName