I have created a Dell KACE report to view specific Dell PC models but need to display the make, model and serial of the hard drive
this is the report I have created:
SELECT M.NAME AS COMPUTER_NAME,CS_MODEL AS MODEL,
DA.SERVICE_TAG,
DATE_FORMAT(DA.SHIP_DATE,'%d/%m/%Y')AS SHIP_DATE,
M.IP AS NETWORK_ADDRESS
FROM KBSYS.DELL_ASSET DA,
MACHINE M
WHERE DA.SERVICE_TAG = M.BIOS_SERIAL_NUMBER && CS_MODEL = 'Optiplex 760'
ORDER BY DA.SHIP_DATE
Just need to add the mkae,model and serial number of the hard drive if possible?
SELECT M.NAME AS COMPUTER_NAME,CS_MODEL AS MODEL,
DA.SERVICE_TAG,
DATE_FORMAT(DA.SHIP_DATE,'%d/%m/%Y')AS SHIP_DATE,
M.IP AS NETWORK_ADDRESS
FROM KBSYS.DELL_ASSET DA,
MACHINE M
WHERE DA.SERVICE_TAG = M.BIOS_SERIAL_NUMBER && CS_MODEL = 'Optiplex 760'
ORDER BY DA.SHIP_DATE
Just need to add the mkae,model and serial number of the hard drive if possible?
Answer Summary:
0 Comments
[ - ] Hide Comments
Answer this question
or Comment on this question for clarity
Answers
I don't think the Kbox captures this level of hard drive info by default. Are you using custom inventory rules / scripts to collect it?
Please log in to comment
Unfortunately, I do not believe that the KACE appliance pulls information that granular about the hard drive. Using the Dell Service Info you could go to the support.dell.com link and see what hard drive orignially shipped with the device. I don't think there is a way to report that.
Please log in to comment
Hi all thanks for all the comments/answers I appreciate the quick response. The reason I want to do this is because we have had a batch of Dell PC's that have had poor performance and found one with unrepairable bad sectors. I wanted the info so I could compare the faulty drive serial against the PC's having a similar issues so we could say for certain it was a dodgy batch of hard drives in the PC's. I am new to Kace and reporting and didn't set up the server so unsure if custom inventory rules / scripts are used to collect the data but could find out if it helps?
Please log in to comment
What I eventually done was create a report of all the Optiplex 760 PC's shipped around a specific date, exported the Kace report to csv then copied out all the IP addresses to a text file. Then created a batch file to copy diskid32.exe to the specified PC's run diskid32.exe and copy the disk info back to a text file on my PC. A bit long-winded but it works. Thanks all.
Please log in to comment
Comments