Is there a way to run a report in Kace to return Dell machines that we have with column that shows each machine's ship date?

The ship date is present under the Hardware section for each machine, but "Ship Date" is not an option in the searches. I'm not sure what the variable is if we do it in SQL.

Answer Summary:
SELECT M.NAME AS Computer_Name, D.SHIP_DATE FROM MACHINE M JOIN KBSYS.DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER ORDER BY NAME For 5.4 SELECT M.NAME AS Computer_Name, D.SHIP_DATE FROM MACHINE M JOIN DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER ORDER BY NAME
Cancel
1 Comment   [ + ] Show Comment

Comments

  • Dugullett's version worked for me but I need additional info, can you please modify it to also show the service tags and only PC that start with SMI? This would be much appreciated, thanks!
Please log in to comment

Answers

3

This just includes name and ship date. If more info is needed let me know.

SELECT M.NAME AS Computer_Name, D.SHIP_DATE

FROM MACHINE M

JOIN KBSYS.DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER

ORDER BY NAME
Answered 08/02/2012 by: dugullett
Red Belt

  • BINGO! This works beautifully. Thank you for not only answering my question, but including all the code necessary.
    Cheers!
  • How come when I copy this code into a report I always get SQL errors? I'm a total SQL newbie so any help would be useful. But if its a simple copy and paste... it should work should it not?

    Here's the error I get....


    mysql error: [1142: SELECT command denied to user 'R1'@'localhost' for table 'DELL_ASSET'] in EXECUTE(
    "SELECT M.NAME AS Computer_Name, D.SHIP_DATE

    FROM MACHINE M

    JOIN KBSYS.DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER

    ORDER BY NAME LIMIT 0")
  • Could depend on unknown variables. Are you adding it to existing code? I used it as the complete code exactly as shown. It will only return data on Dell machines. I built it when our Kace server was at 5.3. We're at 5.4 now, but I'm in the middle of a failed 5.4sp1 update today so I can't test or really get much info at the moment.
    My entire SQL Select Statement is what you see above.
    My Break on Columns field is empty.
    Show line number is checked.
  • No,

    I'm not adding it to existing code, just copied yours exactly as shown above. It looks like it might be an issue with a newer update as I see how old this post is. the whole R1 user is very odd considering I don't have a user called R1 in my KACE system. Iv already opened a ticket with DELL on this after I posted just in case.
    • It looks like the table moved in 5.4. Take out the KBSYS on the JOIN.

      SELECT M.NAME AS Computer_Name, D.SHIP_DATE
      FROM MACHINE M
      JOIN DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER
      ORDER BY NAME
      • Thanks dugullett! That worked!
      • This one worked for me but I need additional info, can you please modify it to display ONLY computer names that start with SMI and also include the service tag? This would be very much appreciated, thanks!
      • SELECT M.NAME AS Computer_Name,BIOS_SERIAL_NUMBER AS 'Service Tag', D.SHIP_DATE
        FROM MACHINE M
        JOIN DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER
        WHERE NAME LIKE 'SMI%'
        ORDER BY NAME
Please log in to comment
Answer this question or Comment on this question for clarity

Share