System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Inventory
>
Report 64bit
Report 64bit
- Hi,
im trying to find out which Computers in our environment can manage 64-Operating Systems. My query is following:
SELECT DISTINCT SYS.Netbios_Name0 FROM v_R_System SYS, v_GS_PROCESSOR PRO
WHERE
PRO.ResourceID = SYS.ResourceID AND PRO.AddressWidth0 = '64'
ORDER BY SYS.Netbios_Name0
But instead of a list of all Computers with AddressWidth0=64 i get all Computers with an existing installation of a 64 Bit Operating System.
I have to say that im not really familiar with SQL. Maybe one of the Gurus out there see what i am doing wrong.
Please advice
Ty
Answers
- so, like this: http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx
where you can tell if a 32bit OS is installed on 64-bit capable hardware?
Standardize. Simplify. Automate.- Marked As Answer bypepschmir Thursday, November 05, 2009 7:43 AM
All Replies
- try this.
http://smsug.ca/blogs/garth_jones/archive/2009/01/28/count-of-os-and-bite-size-32-bit-or-64-bit.aspx
http://www.enhansoft.com/ ty garth,
thats a nice report but it is not what im searchin for. I get a similar result as with the report you posted with my sql-query above. But i don't need a list with the Computers with 64 Bit OS installed.
If i open the Resource-Explorer and browse to the Processorproperties there is a column AdressWidth. We think about deploying win7 only in 64bit version. Thats why I need all Computers with 64 as value in that column to know how many computers need to be replaced.- so, like this: http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx
where you can tell if a 32bit OS is installed on 64-bit capable hardware?
Standardize. Simplify. Automate.- Marked As Answer bypepschmir Thursday, November 05, 2009 7:43 AM
- Thats it, TY Sherry.
