Solved

SCCM Report

Posted on 2011-02-22
7
1,085 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

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

Accepted Solution

by:
socrates2012 earned 500 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

630 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