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