System UUID Report

[berickson]

How could I generate a report that will list the Asset name, asset model, and system UUID?

For example the report would show the name of the machine, the model of the machine, and the UUID of the system

[MikeMc · Accepted solution]

Will something like this work?

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssetCustom.Model,
  tblComputerSystemProduct.UUID
From tblAssets
  Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tblComputerSystemProduct On tblAssets.AssetID =
    tblComputerSystemProduct.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1