Notification

Icon
Error

TPM scanning - How to scan for TPM

Posted: Friday, December 13, 2019 10:40:24 PM(UTC)
gene@sca

gene@sca

Member Original PosterPosts: 1
0
Like
Hey all,

I need some help setting up my LanSweeper to scan for TPM chips onboard PC's.

We do integrations and one of our due diligence steps is to go onsite and perform a full LanSweeper scan before we schedule the network cutover. One of our minimum standards is that TPM chips are required on all desktops, as we use BitLocker for encryption.
I would like to be able to scan the desktops for TPM chips, but I am not sure how to add that into my custom scan report.
mecha
#1mecha Member Posts: 2  
posted: 12/16/2019 12:14:03 PM(UTC)
Report example, TPM info is in the last columns.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblOperatingsystem.InstallDate,
tsysOS.OSname As OS,
tblOperatingsystem.Version As Build,
Case tblOperatingsystem.Version
When '10.0.10240' Then '1507'
When '10.0.10586' Then '1511'
When '10.0.14393' Then '1607'
When '10.0.15063' Then '1703'
When '10.0.16299' Then '1709'
When '10.0.17134' Then '1803'
When '10.0.17763' Then '1809'
When '10.0.18362' Then '1903'
When '10.0.18363' Then '1909'
Else '?'
End As Version,
tblAssetCustom.LastPatched,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblTPM.IsEnabled_InitialValue,
tblTPM.IsActivated_InitialValue,
tblTPM.ManufacturerVersion,
tblTPM.LastChanged,
tblTPM.ManufacturerVersionInfo
From tblAssets
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tblTPM On tblAssets.AssetID = tblTPM.AssetId
Where tblAssetCustom.Model <> 'Virtual Machine' And ((tsysOS.OSname = 'Win 7')
Or (tsysOS.OSname = 'Win 10') Or (tsysOS.OSname Like 'Win 8%')) And
tblAssetCustom.State = 1
Order By tblAssetCustom.PurchaseDate,
tblOperatingsystem.InstallDate Desc

Active Discussions

Lansweeper Asset Out of Warranty & Asset Out of Warranty in 60 Days Reports
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 10:29:35 PM(UTC)
Lansweeper Voip Phone to Computer
by  lansend  
Go to last post Go to first unread
Last post: Yesterday at 1:27:10 AM(UTC)
Lansweeper Report Showing custom registry keys scanned
by  impagian   Go to last post Go to first unread
Last post: 1/23/2020 4:01:34 PM(UTC)
Lansweeper Dell Update v3.0
by  gmw158  
Go to last post Go to first unread
Last post: 1/22/2020 5:42:19 PM(UTC)
Lansweeper Report to compare softwareVersion
by  RC62N   Go to last post Go to first unread
Last post: 1/22/2020 4:57:16 PM(UTC)
Lansweeper Dublicate entries (multiple lines with assetname)
by  wkorrubel  
Go to last post Go to first unread
Last post: 1/22/2020 10:10:28 AM(UTC)
Lansweeper Only show string right of character N
by  RC62N   Go to last post Go to first unread
Last post: 1/20/2020 10:36:12 PM(UTC)
Lansweeper Report From Lansweeper For My Company
by  RC62N  
Go to last post Go to first unread
Last post: 1/17/2020 6:59:47 PM(UTC)