I'm the one who has created the custom report "Before Windows 7 migration".
To be honest, this report has been create in a "quick & dirty" way . So it's not very easy to update it.
If you look at the dataset, I use 4 differents SQL queries.
So if you want to change one or several requierement, you need to review and change all the SQL query
But, the good new is that I've updated this report for Windows 8 migration and simplify it.
Now I based my report on only one SQL query (dataset). The SQL query is a little bit more complex but it's easier to edit it.
Based on this new report, I've create the report you are looking for (I hope) : I've change the requierement to : Processor Speed = 1GHz ; RAM = 2GB; Disk Space = 20GB
Here attached the two reports that you can import : MS WINDOWS 7 PROVISIONING and MS WINDOWS 8 PROVISIONING
Thanks Simon, I will try these reports and let you know if I faced some issue
Just open the .ldms file (with Notepad for instance) and replace the "220.127.116.11" values with "18.104.22.168"
I have done that and after it shows me done. But I cannot see the report under my reports or any other palce
when you import the report, which option do you use?
have you try to log out and log in from the console?
- I select “Insert items into selected group or owner” but i tried the other options also with the same result
- Log off and login didn't work
- I have tried to import your old reports in the other article and it is working fine
I guess it might has something to do with the version, isn't it?
Sorry for the late reply. I have open the report and it is working very good with me. but I am still want to do some customization to remove the Storage condition, I have tried to remove it from the query but still appearing on the report
Can you please take a look
case when OS.OSType LIKE 'Microsoft Windows XP%' then 'Windows XP'
when OS.OSType LIKE 'Microsoft Windows%%2008%' then 'Windows 2008 Serveur'
when OS.OSType LIKE 'Microsoft Windows%%2003%' then 'Windows 2003 Serveur'
when OS.OSType LIKE 'Microsoft Windows%%2000%' then 'Windows 2000 Serveur'
when OS.OSType LIKE 'Microsoft Windows%%Vista%' then 'Windows Vista'
when OS.OSType LIKE 'Microsoft Windows%%7%' then 'Windows 7'
when OS.OSType LIKE 'Microsoft Windows%8%' then 'Windows 8'
end as OS,
(select sum(InstalledSize) from MemorySlot MS where MS.Computer_Idn = C.Computer_Idn) as BytesTotal, P.Type as Processeur, P.MhzSpeed, CS.Manufacturer, LD.DriveLetter, LD.StorageTotal,
case when CS.ChassisType LIKE '%Tower%' OR CS.ChassisType LIKE 'Desktop' OR CS.ChassisType LIKE '%Space%' then 'Desktop'
when CS.ChassisType LIKE '%Laptop%' OR CS.ChassisType LIKE 'Notebook' OR CS.ChassisType LIKE '%Portable%' OR CS.ChassisType IS NULL then 'Laptop'
when CS.ChassisType LIKE '%Server%' OR CS.ChassisType LIKE '%Rack%' then 'Server'
when CS.ChassisType LIKE 'Other' then 'Virtual Machine'
end as Chassis,
case when ((select sum(InstalledSize) from MemorySlot MS where MS.Computer_Idn = C.Computer_Idn) >= 2048 AND P.MhzSpeed >= 1000 AND OS.OSType NOT LIKE 'Microsoft Windows 7%' ) Then 'Compatible'
when (OS.OSType LIKE 'Microsoft Windows 7%') Then 'Already MS Windows 7'
else 'Not Compatible'
end as Compatibility
from Computer C
inner join Operating_System OS ON OS.Computer_Idn = C.Computer_Idn
inner join Memory M ON M.Computer_Idn = C.Computer_Idn
inner join Processor P ON P.Computer_Idn = C.Computer_Idn
inner join CompSystem CS ON CS.Computer_Idn = C.Computer_Idn
inner join LogicalDrives LD ON LD.Computer_Idn = C.Computer_Idn AND LD.DriveLetter = 'C'
1 of 1 people found this helpful
Indeed, you've just change in query the condition to detect compatible device (which is good).
But if you want to remove Storage information from the report, you need to change the report UI.
In the report, there are 2 things to change :
1- In the "Not Compatible Devices Summary" graphics : in Datas > Values , remove the Storage value.
2 - In the "Not Compatible Devices List" table : remove the "Total Sotage (C:) column
Finally, you can remove the LD.StorageTotal field in the SQL Query as it's no longer use but it doesn't matter...
Man, you saved me big time. thanks.
Where can I get more information about report design, I can see most of the documents here are old.