Solved

report sccm of the machines on the site with SQL Server installed

Posted on 2010-08-30
3
609 Views
Last Modified: 2013-11-21

I need to create a report sccm of the machines on the site with SQL Server installed and their versions

Thanks
0
Comment
Question by:ggarate
3 Comments
 
LVL 14

Expert Comment

by:Abduljalil Abou Alzahab
ID: 33565906
You can check Create a Report SQL Statement in Query Designer and Create a New Configuration Manager Report
http://technet.microsoft.com/en-us/library/dd334679.aspx

For additional information, Scenarios for Creating Custom Reports
http://technet.microsoft.com/en-us/library/dd334620.aspx
0
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 500 total points
ID: 33586891
Hi
this is the SQl query statement you need add it to your report and it will work :


SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.Domain0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0
FROM         v_GS_SYSTEM INNER JOIN
                      v_GS_SERVICE ON v_GS_SYSTEM.ResourceID = v_GS_SERVICE.ResourceID
WHERE     (v_GS_SERVICE.DisplayName0 = 'SQL Server (MSSQLSERVER)')
0
 

Author Closing Comment

by:ggarate
ID: 33591038
Thanks a lot
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

803 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