Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SCCM Report

Posted on 2011-02-22
7
Medium Priority
?
1,095 Views
Last Modified: 2013-11-21
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
Comment
Question by:m1721c
  • 3
  • 2
  • 2
7 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 34953854
Why not just run the computer summary report that is a standard report?
0
 

Author Comment

by:m1721c
ID: 34954395
can find it, can you send me it?
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 34956152
SCCM 2007 sp2?
0
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

 

Author Comment

by:m1721c
ID: 34956167
yes sp2 r2
0
 
LVL 3

Accepted Solution

by:
socrates2012 earned 2000 total points
ID: 34961562
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
 

Author Comment

by:m1721c
ID: 35404325
This doesn't work I may be addidng it into SCCM wrong.  I'm a noob with this.
0
 
LVL 3

Expert Comment

by:socrates2012
ID: 35404366
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Case Summary: In this Article we introduce the new method to configure the default user profile using Automated profile copy with sysprep rather than the old ways such as the manual copy of a configured profile to default user profile Old meth…
On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Screencast - Getting to Know the Pipeline

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question