cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

All Hardawre REPORT

Ruhollah
Engaged Sweeper
Hi . I have a report that show all hardware in one report ( use having and grouping for remove multiple items). it was okey until add printers to report .
after adding printers , Assest that don't have printer installed removed from report . how can i
show Assest tha don't have printer ?


my report :


Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblPhysicalMemory.Speed,
tblAssets.Memory,
tblADusers.Title,
tblAssets.Username,
tblADusers.Displayname,
tblADusers.HomePage,
tblAssetCustom.Model,
tblBaseBoard.Product,
tblBaseBoard.Manufacturer As Manufacturer1,
tblAssets.Mac,
tblAssets.IPAddress,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tsysOS.OScode,
tblBIOS.SMBIOSBIOSVersion,
tblBIOS.ReleaseDate,
tblProcessor.Name As CPU,
tblProcessor.MaxClockSpeed As CPUSpeed,
tblPrinters.Caption
From tblAssets
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType =
TsysMemorytypes.Memorytype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBoard.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblBaseBoard.Product <> '440BX Desktop Reference Platform' And
tblAssetCustom.State = 1 And tblPrinters.Portname Not Like '%.%.%.%'
And tblPrinters.Portname Not Like '%WSD%' And tblPrinters.Portname <> 'TPVM'
And tblPrinters.Printprocessor <> 'WinPrint'
Group By tsysOS.Image,
tblAssets.AssetID,
tblAssets.AssetName,
tblPhysicalMemory.Speed,
tblAssets.Memory,
tblADusers.Title,
tblAssets.Username,
tblADusers.Displayname,
tblADusers.HomePage,
tblAssetCustom.Model,
tblBaseBoard.Product,
tblBaseBoard.Manufacturer,
tblAssets.Mac,
tblAssets.IPAddress,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname,
tsysOS.OScode,
tblBIOS.SMBIOSBIOSVersion,
tblBIOS.ReleaseDate,
tblProcessor.Name,
tblProcessor.MaxClockSpeed,
tblPrinters.Caption,
tblAssetCustom.Manufacturer
0 REPLIES 0