Inventory Report for Broadwell or Haswell Processors

0

Hi All,

Since Intel is now saying that Broadwell and Haswell processors are experiencing random reboots after being patched for Meltdown/Specter, I was hoping to create a Report to find which machines have these processors.

I have created a report with Inventory that shows me the Computer Name, CPU Processor, and Computer Model. However, I have to manually go through the report and look at each item and compare it to Intel's lists at https://ark.intel.com/products/codename/38530/Broadwell and https://ark.intel.com/products/codename/42174/Haswell. That is very time consuming.

Does anyone have any way to make this easier with Inventory?

Cancel
login to comment
0

Here's what I did:

Generate a processor report in PDQ Inventory, export to CSV

Do a "select all" on the the pages you reference above and copy to Notepad++, and strip out any text that's not part of the tables

Copy the left over text from Notepad++ to Excel, and strip out the columns that don't contain the processor ID

Copy back the column of processor IDs back to Notepad++

Strip out anything that isn't the actual processor ID, such as Intel, Pentium, Xeon, Core, etc.

Save that list of processors as a text file in c:\temp\processors\broadwell-haswell.txt

Copy the CSV report file from PDQ Inventory to c:\temp\processors\processorReport.csv

Use findstr, as follows: "findstr /g:c:\temp\broadwell-haswell.txt c:\temp\processorReport.csv > c:\temp\processors\out.txt

Copy the header line from c:\temp\processors\processorReport.txt to the first line of c:\temp\processors\out.txt

Out.txt should contain the data you want.

Took me about 10 minutes to do this.

Kurt

Cancel
login to comment

Reply