/build/static/layout/Breadcrumb_cap_w.png

Software Question


Make detailed report with assets

12/05/2014 3113 views
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:
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.

All 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
2nd 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.
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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ