→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
berickson
Engaged Sweeper
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
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
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