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

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


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

Thanks
0
ggarate
Asked:
ggarate
1 Solution
 
Abduljalil Abou AlzahabInfrastructure Team Leader – Professional ServicesCommented:
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
 
TarekIsmailCommented:
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
 
ggarateAuthor Commented:
Thanks a lot
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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