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
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
mikesharp1
9 years ago
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
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
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
Have you tried to create a Custom Report ton that specific asset type?
Kind regards,
Marco = StockTrader - StockTrader 9 years ago