/build/static/layout/Breadcrumb_cap_w.png

Make detailed report with assets

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.

3 Comments   [ + ] Show comments
  • Just to clarify, you want to export information that is contained in the "Inventory" section but not contained in the "Asset" section? - Ben M 9 years ago
  • 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 - StockTrader 9 years ago
  • 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. - MesaMe 9 years ago

Answers (2)

Answer Summary:
Posted by: mikesharp1 9 years ago
2nd Degree Black Belt
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


Comments:
  • 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? - MesaMe 9 years ago
    • do you not see the table information? - mikesharp1 9 years ago
      • your cell phone information will be stored in the asset table information which you will need to left outer join to that table. - mikesharp1 9 years ago
Posted by: MesaMe 9 years ago
Purple Belt
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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