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?
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
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?
Answered 03/27/2012 by: dchristian
Red Belt

Please log in to comment
0
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.
Answered 03/27/2012 by: Hammer1790
Second Degree Black Belt

Please log in to comment
0
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.
Answered 03/27/2012 by: ckubaska
Fourth Degree Brown Belt

Please log in to comment
0
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?
Answered 03/28/2012 by: JonWest
White Belt

Please log in to comment
0
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.
Answered 03/28/2012 by: JonWest
White Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share