Report of machines by ship date
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.
1 Comment
[ + ] Show comment
-
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! - ITSamurai9 7 years ago
Answers (1)
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
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
Please log in to answer
Posted by:
dugullett
11 years ago
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
Comments:
-
BINGO! This works beautifully. Thank you for not only answering my question, but including all the code necessary.
Cheers! - murbot 11 years ago -
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") - spassler 11 years ago -
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. - murbot 11 years ago -
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. - spassler 11 years ago-
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 - dugullett 11 years ago-
Thanks dugullett! That worked! - spassler 11 years ago
-
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! - ITSamurai9 7 years ago
-
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 - dugullett 7 years ago
-
How can I add in last logged in user? - haynie777 7 years ago
-
Also, wonder if I can filter on label or operating systems to show servers and workstations separate. - haynie777 7 years ago
