Report to see wich devices have a USB-C port

[SteveHernou]

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

[rader]

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

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

[David_GF]

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

[SteveHernou]

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.

[ErikT]

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