→ 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: 
poprock
Engaged Sweeper
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.
1 REPLY 1
RCorbeil
Honored Sweeper II
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.