SCCM Report

I need configure a report that will show the computer name and what os it has, as well as the version(32bit or 64bit).  I need to be able to target a collection.

Who is Participating?
socrates2012Connect With a Mentor Commented:
select sys.netbios_name0, sys.Operating_System_Name_and0 as OperatingSystem,
case when pr.addresswidth0 = 64 then '64bit OS'
when pr.addresswidth0=32 then '32bit OS'
end as [Operating System Type],
case when pr.addresswidth0=32 and pr.DataWidth0=64 then '*'
end as [32-bit OS on x64 processor]
from v_r_system sys
join v_gs_processor pr on sys.resourceid=pr.resourceid  
JOIN v_FullCollectionMembership ON v_FullCollectionMembership.ResourceID = sys.ResourceID
WHERE v_FullCollectionMembership.CollectionID =@ID

********************Prompts Query to select collection (make sure to name prompt ID)**********
 if (@__filterwildcard = '')
  SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
  SELECT DISTINCT CollectionID, Name FROM v_Collection
  WHERE CollectionID like @__filterwildcard

Neil RussellTechnical Development LeadCommented:
Why not just run the computer summary report that is a standard report?
m1721cAuthor Commented:
can find it, can you send me it?
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Neil RussellTechnical Development LeadCommented:
SCCM 2007 sp2?
m1721cAuthor Commented:
yes sp2 r2
m1721cAuthor Commented:
This doesn't work I may be addidng it into SCCM wrong.  I'm a noob with this.
Paste everything above the star line into the main report.  Every below copy and click on the Prompts button to the right of the main text box.  Make a new prompt called ID, paste the code.

If still having problems specify the errors you are receiving please.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.