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

Report for SCCM with SQL Server machines and version of sql installed

I have this SQL statement

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"')

To get a report in which besides sql 2005, I say the sql 2000 express on the domain that anyone could guide me?

Thanks
0
ggarate
Asked:
ggarate
  • 5
  • 3
1 Solution
 
TarekIsmailCommented:
HI ,
could you please check this

SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0, v_GS_SYSTEM.Domain0, v_HS_INSTALLED_SOFTWARE.ARPDisplayName0
                     
FROM         v_HS_INSTALLED_SOFTWARE INNER JOIN
                      v_GS_SYSTEM ON v_HS_INSTALLED_SOFTWARE.ResourceID = v_GS_SYSTEM.ResourceID
 where ARPDisplayName0 like '%SQL%'  


please update me if you need more things

Good Luck!
Tarek Ismail
0
 
TarekIsmailCommented:
to get domain controllers running any SQL
=================================

SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0, v_GS_SYSTEM.Domain0, v_HS_INSTALLED_SOFTWARE.ARPDisplayName0
                     
FROM         v_HS_INSTALLED_SOFTWARE INNER JOIN
                      v_GS_SYSTEM ON v_HS_INSTALLED_SOFTWARE.ResourceID = v_GS_SYSTEM.ResourceID
 where ARPDisplayName0 like '%SQL%'
 and SystemRole0 ='domain'      
0
 
TarekIsmailCommented:
i hope my answer help you !
please let me know if you need more help
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
TarekIsmailCommented:
Hi ggarate,

it seems you ask to close the question , and this will take 4 days
0
 
ggarateAuthor Commented:
Gives the correct result, but I need to filter only by SQL Server, either version 2000, 2005 or 2008

Regards
0
 
TarekIsmailCommented:
can you open it in new question ?
as we already finish this one , right?
0
 
ggarateAuthor Commented:
Correct, but how name the question? Thanks
0
 
ggarateAuthor Commented:
Thanks
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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