I was wondering how to add the installed software on a computer to my script. This will be exported into another database where each user will have a software tab which should list the current installed software from kace
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
Answers (1)
Build a report in the report wizard in the K1000 and then import it into your database.
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.
