In my inventory in K1000 I have registered cell phones and paptops amongst others. Is it possible to make a report containing user, SN, model, make/producer, etc? It seems like the only option now is exporting to a CSV-file with onformation that are in the coloms in the asset list and I need a report containing more information than that.
Answer Summary:
Cancel
3 Comments   [ + ] Show Comments

Comments

  • Just to clarify, you want to export information that is contained in the "Inventory" section but not contained in the "Asset" section?
  • So if I understood correctly you created some asset types and imported some data.
    Have you tried to create a Custom Report ton that specific asset type?
    Kind regards,
    Marco = StockTrader
  • I want a custom reports which displays user, computer model, SN, ID/name of computer of the computer and IMEI, owner/user, make/model of cell phones registered in the asset-part of KACE 1000.
Please log in to comment

Answers

0

If that information listed you can probably grab it.

Here's a simple SQL script to pull the service tag, name of the machine and model.

Select
  ORG1.MACHINE.BIOS_SERIAL_NUMBER,
  ORG1.MACHINE.CS_MODEL,
  ORG1.MACHINE.NAME
From
  ORG1.MACHINE

Answered 12/08/2014 by: mikesharp1
Second Degree Black Belt

  • Thanks. Do you know if there is a list of values for the ORG1.MACHINE-values? I pretty much got what I wanted from this query. I just needed to ad "ORG1.MACHINE.USER_FULLNAME" into the query.

    What are the eqvuvalent values for cell-phones?
    • do you not see the table information?
      • your cell phone information will be stored in the asset table information which you will need to left outer join to that table.
Please log in to comment
0
I have this Query which mostly gives me what I want. I need to get the IMEI and SN as well. How do I do that?

SELECT  ASSET.NAME AS ASSET_NAME ,  IF(U0.FULL_NAME != '', U0.FULL_NAME, U0.USER_NAME) AS FULL_NAME0 , AD.FIELD_49 as 'Type mobil', AD.FIELD_59 as 'Farge', AD.FIELD_50 as 'Mobil nummer', AD.FIELD_51 as 'Dato'      FROM ASSET
             LEFT JOIN USER U ON U.ID = ASSET.OWNER_ID
             LEFT JOIN MACHINE M ON ASSET.MAPPED_ID = M.ID and ASSET.ASSET_TYPE_ID = 5
             LEFT JOIN ASSET_DATA_14 AD ON AD.ID = ASSET.ASSET_DATA_ID       LEFT JOIN USER U0 ON U0.ID = AD.FIELD_54
 where ASSET.ASSET_TYPE_ID = 14 GROUP BY ASSET.ID ORDER BY ASSET_NAME
Answered 12/18/2014 by: MesaMe
Purple Belt

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

Share