K1000 Reporting: Computer model
I am trying to create a simple report on all computers in our inventory that is grouped by models and ordered by location labels i created using IP address ranges. I can see the Model attribute under the Comupter Name in the inventory detail page of the K1000, but I can't find it in either the report wizard or browsing the database tables. Where is the K1000 getting this model so i can use it to create a report?
0 Comments
[ + ] Show comments
Answers (3)
Answer Summary:
Please log in to answer
Posted by:
SMal.tmcc
11 years ago
Comments:
-
This worked. Now I can get the SQL from the wizard. Thanks. - lmland 11 years ago
Posted by:
Timi
11 years ago
SELECT NAME, CS_MANUFACTURER, CS_MODEL FROM MACHINE ORDER BY CS_MODEL, NAME
Posted by:
dugullett
11 years ago
You can enter your label name on this one.
SELECT M.NAME, CS_MODEL FROM MACHINE M LEFT JOIN MACHINE_LABEL_JT MLJT ON M.ID = MLJT.MACHINE_ID LEFT JOIN LABEL L ON MLJT.LABEL_ID = L.ID WHERE L.NAME = '<LABEL_NAME>' ORDER BY CS_MODEL
or if you didn't want to use your labels, and just IPs.
SELECT M.NAME, CS_MODEL FROM MACHINE M WHERE IP LIKE '192.168.10%' ORDER BY CS_MODEL
