Help With a report for Assets & Chassis types

[chrisells]

Hi,

Can someone help me out with a report. Everything i do doesn't seem to work.

I need the following information:

All Active Assets: Laptops, Notebooks, Portable, Desktops, (these are Chassis types)

Info required:

AD Description, Chassis type, OS, Make, Model, IP Location

Please let me know if you require anymore information.

Any help will be appreciated.

Cheers.

Chris

[MikeMc]

This query should get you started.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblADComputers.Description,
  TsysChassisTypes.ChassisName,
  tblOperatingsystem.Caption As OS,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  (Case
    When tsysIPLocations.IPLocation Is Not Null Then tsysIPLocations.IPLocation
    Else 'Undefined' End) As IPLocation
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblADComputers On tblADComputers.AssetID = tblAssets.AssetID
  Inner Join tblSystemEnclosure On tblSystemEnclosure.AssetID =
    tblAssets.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes
  Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
    tblAssets.AssetID
  Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
    And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where (TsysChassisTypes.ChassisName = 'Laptop' Or TsysChassisTypes.ChassisName =
    'Notebook' Or TsysChassisTypes.ChassisName = 'Portable' Or
    TsysChassisTypes.ChassisName = 'Desktop') And tblAssetCustom.State = 1
Order By tblAssets.AssetName