Processor List on Reports
Hi folks,
Im trying to create a report of all the computers included in the inventory, and in the Processors column it shows this info:
| CPU Chip Count: 1 CPU Core Count: 4 CPU0: Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz (4 cores) |
Is there any way to exclude just the first two lines??? I want to show just the "CPU0" line, or maybe if the computer has more than 1 CPU, also show them (CPU1, CPU2, etc).
How should i edit the SQL for that column?
Thank you
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
a simple query like SELECT MACHINE.ID, SYSTEM_DESCRIPTION, MACHINE.NAME AS SYSTEM_NAME, PROCESSORS FROM MACHINE WHERE ((PROCESSORS like '%-13%') OR (PROCESSORS like '%-14%')) ORDER BY MACHINE.ID would show the nessesary info (you also can simply click it together in thw wizard - Nico_K 2 months ago