cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ifm
Champion Sweeper
We are planning our upgrade of current Windows XP computers to Windows 7.

Is it possible to generate a report with computers currently running Windows XP with 64-bit capable CPU and the current amount of RAM and HDD? (can you show me an example of how to create this)

Also a report with XP computers that not could be upgraded would be great. 32 bit only CPU and less then 2 GB RAM.


/David
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Processor architecture (x86/x64) is stored in the Architecture field of tblPROCESSOR. This field should be populated for Windows XP machines as well.

Could you try the report below for the information you are after. It includes Windows XP machines and their processor architecture, RAM and C: disk size. A custom Status column marks machines that cannot be upgraded. These are machines with a 32-bit processor or less than 2GB RAM, as per your requirements.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Case tblPROCESSOR.Architecture When 0 Then '32-bit' When 1 Then 'MIPS' When 2 Then 'Alpha' When 3 Then 'PowerPC' When 5 Then 'ARM' When 6 Then 'Itanium-based systems' When 9 Then '64-bit' Else 'unknown' End As [Processor Architecture], web40CorrectMemory.Memory, Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [C Disk Size in GB], Case When tblPROCESSOR.Architecture = 0 or web40CorrectMemory.Memory < 2048 Then 'cannot be upgraded' End As Status, tblComputers.Lastseen From tblComputers Left Join tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername Left Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Left Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Where Web40OSName.OSname = 'win xp' And tblDiskdrives.Caption = 'c:' Order By tblComputers.ComputerUnique

View solution in original post

15 REPLIES 15
ifm
Champion Sweeper
It looks like there are a bug in how Lansweeper reads the CPU.

ex. Latitude E6410
OS: Windows XP Professional SP3
Memory: 4096 MB
Processor: 1 * Intel Pentium II processor
Domain: AD
Support: Dell Inc. - BW9BVM1
First seen:
2010-09-08 10:33:51
Last seen:
2012-09-24 23:27:24
Last tried: 2012-09-27 23:24:42

I don't think it has a Pentium II processor 😉
ifm
Champion Sweeper
Thank you!

It looks like the report show CPU architecture based on the OS currently installed. All XP 32-bit computers show 32-bit and cannot be upgraded and all XP 64 bit show 64-bit and can be upgraded.

The other information is good, RAM, disk & last seen. 🙂
Hemoco
Lansweeper Alumni
ifm wrote:
It looks like the report show CPU architecture based on the OS currently installed.

It shouldn't. The Processor Architecture column pulls from the tblPROCESSOR.Architecture field, not the OS architecture. Could you ensure that your machines have recently been successfully scanned and that you are looking at the latest available computer information.
Hemoco
Lansweeper Alumni
Processor architecture (x86/x64) is stored in the Architecture field of tblPROCESSOR. This field should be populated for Windows XP machines as well.

Could you try the report below for the information you are after. It includes Windows XP machines and their processor architecture, RAM and C: disk size. A custom Status column marks machines that cannot be upgraded. These are machines with a 32-bit processor or less than 2GB RAM, as per your requirements.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Case tblPROCESSOR.Architecture When 0 Then '32-bit' When 1 Then 'MIPS' When 2 Then 'Alpha' When 3 Then 'PowerPC' When 5 Then 'ARM' When 6 Then 'Itanium-based systems' When 9 Then '64-bit' Else 'unknown' End As [Processor Architecture], web40CorrectMemory.Memory, Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [C Disk Size in GB], Case When tblPROCESSOR.Architecture = 0 or web40CorrectMemory.Memory < 2048 Then 'cannot be upgraded' End As Status, tblComputers.Lastseen From tblComputers Left Join tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername Left Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Left Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Where Web40OSName.OSname = 'win xp' And tblDiskdrives.Caption = 'c:' Order By tblComputers.ComputerUnique
mdouglas
Engaged Sweeper III
I don't think it's possible (at least for Lansweeper) to detect whether a processor is 64-bit capable on a Windows XP machine unless it's running Windows XP x64.

There's a built-in report called "Computer: 64 bit processor but 32 bit OS installed" that I tried tinkering with, but I couldn't get it to show Windows XP machines.

For the other information you're looking for, you can just click on a specific domain in the "Domain Overview" and that will give Name, OS, Memory, CPU, etc.

Also as a note, there is a 32-bit version of Windows 7 that only has a 1GB memory minimum requirement. We have quite a few machines running this with only 1GB memory and they seem to work great for non-CPU intensive day-to-day activities.
ifm
Champion Sweeper
mdouglas wrote:

Also as a note, there is a 32-bit version of Windows 7 that only has a 1GB memory minimum requirement. We have quite a few machines running this with only 1GB memory and they seem to work great for non-CPU intensive day-to-day activities.


Thank you for your reply. I also expect an answer from the Lansweeper support team, they are usually quick to reply.

32 bit Windows 7 is not an option. We want to have the same OS on all clients to make software distribution easier. Too old computers will end up in our lab environment.