Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2010-08-30
3
Medium Priority
?
622 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 2000 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

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.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

605 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