Reports: No Trend Micro Disk Encryption

[poprock]

Hello,

I am new here and also new in LANSweeper. Can someone help me create a report on how to identify machine which doesn't have Trend Micro Disk Encryption installed? We are using Windows 7, 8 (both 64bit) on our environment.

We are also using MAC OS machines here. It would be much appreciated if you also include this on the reports.

Thanks and God Bless.

[RCorbeil]

On the Windows side, you can use something like this as a starting point:

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
Where
  tblAssetCustom.State = 1
  AND tblAssets.Assettype = -1
  AND tblAssets.AssetID NOT IN
    (SELECT tblSoftware.AssetID
     FROM tblSoftware INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
     WHERE tblSoftwareUni.softwareName Like '%Your Software%')

Substitute a unique portion of your Trend Micro software name for "Your Software", e.g. if the name literally appears as "Trend Micro Disk Encryption", use that. The % are wildcards, so the query reads as "software name contains 'Your Software'.

I don't have any Macs in the inventory I support, so I can't help with that.