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?
0 Comments
[ + ] Show comments
Answers (5)
Answer Summary:
Please log in to answer
Posted by:
dchristian
12 years ago
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?
Posted by:
Hammer1790
12 years ago
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.
Posted by:
ckubaska
12 years ago
I've not looked but if that information is in the bios you might be able to use CCTK (Dell Client Configuration Tool Kit) to pull it into kbox and then run a report.
Posted by:
JonWest
12 years ago
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?
Posted by:
JonWest
12 years ago
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.