→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-26-2012 04:35 PM
Solved! Go to Solution.
‎09-28-2012 12:41 PM
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
‎10-30-2012 03:00 PM
‎10-31-2012 02:35 PM
ifm wrote:
Can you please modify this report to print out computer model and CPU name instead of 32/64 bit?
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model, Web40OSName.OSname As OS, tblPROCESSOR.Name As CPU, web40CorrectMemory.Memory, Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [C Disk Size in GB], 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 Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where Web40OSName.OSname = 'win xp' And tblDiskdrives.Caption = 'c:' Order By tblComputers.ComputerUnique
‎10-18-2012 07:01 PM
c:\>wmic path win32_processor >lansweepertest.txt
‎10-18-2012 05:35 PM
‎10-08-2012 08:33 PM
‎10-07-2012 02:22 PM
‎10-10-2012 05:33 PM
fjca wrote:
We have that hotfix installed in our machines and the end result is the same, tblPROCESSOR.Architecture is set to 0, even if the CPU is 64-bit capable. I think they've just fixed the CPU name, not all the underlying details.
mdouglas wrote:
That's pretty much the same thing I was experiencing, which is why I said I couldn't get it to work 🙂
‎09-28-2012 05:53 PM
‎09-28-2012 01:04 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now