cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
leblanc_daniel_
Engaged Sweeper III
Report for inventory, i suck a creating report please help.
I need a report that can give me username, computer name, computer model, computer s/n, IP addresse, OS name, domaine name , warranty and Vendor.

Thank you for help

Dan
5 REPLIES 5
john_knapik
Engaged Sweeper
I do not know of a field for vendor , but it could be a custom field

post a screen shot of your assets and of the report result
leblanc_daniel_
Engaged Sweeper III
There seems to ba a limit of Pc and client i only show 65 out of 200..?
Do you know why?

Thanks

Dan
leblanc_daniel_
Engaged Sweeper III
Sorry what do you meen? papulate all information come from the scan

Dan
john_knapik
Engaged Sweeper
how did you populate the vendor information?
john_knapik
Engaged Sweeper
working on the vendor but here is a start
Select Top 1000000 tblAssets.Username,
tblAssets.AssetUnique,
tblAssetCustom.AssetID,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As Serial,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.Domain,
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblAssetCustom.PurchaseDate As [Purchase Date],
tsysOS.Image As icon
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblAssetCustom.PurchaseDate Is Not Null And tblAssetCustom.State = 1) Or
(tblAssetCustom.Warrantydate Is Not Null And tblAssetCustom.State = 1)
Order By [Warranty Expiration] Desc