Need help creating report

[SebastianR7]

I'm SQL-tarded so be gentle.


I need to create a report in LS 5069 that gives me the following info...all Laptops/Desktops with serial number, computer name, model type, Username, IP address and location.

Can someone help me out?

Thanks in advance!

[RCorbeil]

I only have Windows machines in my database to report on so I can't answer that. Sorry.

[SebastianR7]

Is there a ChassisType specification for Macs?

[Hemoco]

SebastianR7 wrote:
Is there a ChassisType specification for Macs?

This information is not currently scanned for Macs. Chassis information is only retrieved for Windows and Linux.

[RCorbeil · Accepted solution]

Something like this?

Select Top 1000000
  tsysOS.Image As icon,
  tsysOS.OSname,
  tblAssets.Domain,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Username,
  tblAssets.Description,
  tSysChassisTypes.ChassisName,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.SerialNumber,
  tblAssets.IPAddress,
  tblAssetCustom.Location,
  tbldomainroles.Domainrolename
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tbldomainroles On tbldomainroles.Domainrole = tblComputersystem.Domainrole
  Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes = TsysChassisTypes.Chassistype
Where
  tblAssetCustom.State = 1
  And tbldomainroles.Domainrole < 2
  And TsysChassisTypes.ChassisName <> 'Docking Station'
Order By
  tblAssets.AssetUnique

The IP address stored in tblAssets isn't always as current as what's found in tblNetwork, but winnowing down the contents of tblNetwork can be a little messy.