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?

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

Answered 03/18/2013 by: SMal.tmcc
Red Belt

  • This worked. Now I can get the SQL from the wizard. Thanks.
Please log in to comment
1

SELECT NAME, CS_MANUFACTURER, CS_MODEL FROM MACHINE ORDER BY CS_MODEL, NAME

Answered 03/18/2013 by: Timi
Seventh Degree Black Belt

Please log in to comment
1

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
Answered 03/19/2013 by: dugullett
Red Belt

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

Share