/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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