• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1108
  • Last Modified:

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.


Thanks
0
m1721c
Asked:
m1721c
  • 3
  • 2
  • 2
1 Solution
 
Neil RussellTechnical Development LeadCommented:
Why not just run the computer summary report that is a standard report?
0
 
m1721cAuthor Commented:
can find it, can you send me it?
0
 
Neil RussellTechnical Development LeadCommented:
SCCM 2007 sp2?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
m1721cAuthor Commented:
yes sp2 r2
0
 
socrates2012Commented:
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)**********
begin
 if (@__filterwildcard = '')
  SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
 else
  SELECT DISTINCT CollectionID, Name FROM v_Collection
  WHERE CollectionID like @__filterwildcard
  ORDER BY Name
end

0
 
m1721cAuthor Commented:
This doesn't work I may be addidng it into SCCM wrong.  I'm a noob with this.
0
 
socrates2012Commented:
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.
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now