Select
  A20.NAME AS USER_NAME,
  ASSET_DATA_5.FIELD_23 AS EMAIL_ADDRESS,
  ASSET_DATA_5.FIELD_22 AS LOCATION,
  MACHINE.NAME AS COMPUTER_NAME,
  IP AS I_P_ADDRESS,
  MACHINE.CS_MODEL AS MODEL_TYPE,
  MACHINE.CHASSIS_TYPE AS CHASSIS_TYPE,
  MACHINE.OS_NAME AS OPERATING_SYSTEM,
  MACHINE.SERVICE_PACK AS SERVICE_PACK,      
  BIOS_SERIAL_NUMBER AS SERIAL_NUMBER,
  MACHINE.RAM_Total AS R_A_M,
  DATE_FORMAT (D.SHIP_DATE, '%M %D, %Y') AS SHIP_DATE,
  MACHINE.USER_NAME AS LAST_LOGON_USER
 
From
  MACHINE Left Join
  ASSET On ASSET.MAPPED_ID = MACHINE.ID And ASSET.ASSET_TYPE_ID = 5 Left Join
  ASSET_ASSOCIATION J20 On J20.ASSET_ID = ASSET.ID And J20.ASSET_FIELD_ID = 20
  Left Join
  ASSET A20 On A20.ID = J20.ASSOCIATED_ASSET_ID Left Join
  ASSET_DATA_5 On ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID Left Join
  KBSYS.DELL_ASSET D On D.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER
Where
  A20.NAME != ''
Order By
  A20.NAME,
  ASSET_DATA_5.FIELD_23

Answer Summary:
Build a report in the report wizard in the K1000 and then import it into your database.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Does your additional database have an import feature, specifically for .xls?  If so, you should be able to build a report in the report wizard in the K1000 and then import it into your database.

Answered 11/12/2012 by: jknox
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity