Hello.  I am trying to get a report to list the users on our inventory report.  Here is what I have so far:  I am using smart labels to list the different buildings subnets

SELECT DISTINCT M.NAME AS NAME, M.CHASSIS_TYPE AS MAKE, M.CS_MODEL AS MODEL, M.BIOS_SERIAL_NUMBER AS SERVICE_TAG, L.NAME AS LOCATION, DA.SHIP_DATE
FROM MACHINE M
LEFT JOIN KBSYS.DELL_ASSET DA ON (DA.SERVICE_TAG = M.BIOS_SERIAL_NUMBER)
JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)
JOIN LABEL L ON (ML.LABEL_ID = L.ID)
WHERE (L.NAME rlike')
ORDER BY LOCATION
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Add USER_LOGGED to your select statement.

Answered 12/14/2012 by: dugullett
Red Belt

  • Keep in mind that if no user was logged in at inventory then this field will be blank.
Please log in to comment
Answer this question or Comment on this question for clarity