I need a report from all desktops, but this report I created is not showing me all the desktops. And I need all states not only Active.
What I need:
- Statename (all states)
- Assetname
- Usedby (userrelation)
- Username
- Model
- Manufacture
- Custom 2
- OS (All Windows Desktops)
- LastScan
- Processor
- Memory
- Purchase
- Warranty
- Building
- Department
- Location
- Custom 1
Select Top 1000000 tblstate.Statename,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetUserRelations.Username As [Usado por],
tblAssets.Username As [Ultimo Login],
tblAssetCustom.Model As Modelo,
tblAssetCustom.Manufacturer As Fabricante,
tblAssetCustom.Custom2 As Patrimonio,
tsysOS.OSname As OS,
tblComputersystem.Lastchanged As [Ultimo Scan],
tsysOS.Image As icon,
tblAssets.Processor As Processador,
tblAssets.Memory As Memoria,
tblAssetCustom.PurchaseDate As Compra,
tblAssetCustom.Warrantydate As Garantia,
tblAssetCustom.Building As [Predio/Obra],
tblAssetCustom.Department As Departamento,
tblAssetCustom.Location As Local,
tblAssetCustom.Custom1 As Obs
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblstate On tblAssetCustom.State = tblstate.State
Inner Join tblAssetUserRelations On tblAssets.AssetID =
tblAssetUserRelations.AssetID
Where tblComputersystem.Domainrole < 2
Order By tblAssets.AssetName
Thanks in advance
