cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SteveHernou
Engaged Sweeper

Hi

We're trying to figure out a report to list whether or not a laptop has a USB-C type port but so far no luck.

Anyone already faced a similar challenge in the past and has a solution? 🙂

Cheers

4 REPLIES 4
rader
Champion Sweeper III

I ran the report Port:USB (built-in report I believe) and came up with this snapshot.

rader_0-1662655255806.png

Looking for the ExternalReferenceDesignator field in tblPortConnector may provide answers you're looking for.

David_GF
Lansweeper Tech Support
Lansweeper Tech Support

Doing a small modification on the built-in Port: USB report to filter only by assets with a Type C USB port:

 

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblPortConnector.ExternalReferenceDesignator,
tblPortConnector.InternalReferenceDesignator,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblPortConnector On tblAssets.AssetID = tblPortConnector.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1 And tblPortConnector.PortType = 16 And tblPortConnector.ExternalReferenceDesignator like '%Type C%'
Order By tblAssets.AssetName

 

 



~~~~~~~ (〃 ̄︶ ̄)人( ̄︶ ̄〃) ~~~~~~~
Sweep that LAN, sweep it!

Thanks for the tip 🙂 Unfortunately it seems a lot of devices are not reporting anything in the Ports section. None of our Microsoft Surface devices show up (also not in the built-in report) and also some HP models are missing. I'll keep looking.

SteveHernou_0-1663146651759.png

SteveHernou_1-1663146682039.png

 

ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@SteveHernou I have changed the labels of your post to Report Center and Finished reports. Your question likely will get more traction there.