Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-09-14
10
Medium Priority
?
831 Views
Last Modified: 2013-11-21
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
Comment
Question by:ggarate
[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
  • 5
  • 3
10 Comments
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33698273
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
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 2000 total points
ID: 33698287
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
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33720201
i hope my answer help you !
please let me know if you need more help
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33732171
Hi ggarate,

it seems you ask to close the question , and this will take 4 days
0
 

Author Comment

by:ggarate
ID: 33745708
Gives the correct result, but I need to filter only by SQL Server, either version 2000, 2005 or 2008

Regards
0
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33746408
can you open it in new question ?
as we already finish this one , right?
0
 

Author Comment

by:ggarate
ID: 33746423
Correct, but how name the question? Thanks
0
 

Author Closing Comment

by:ggarate
ID: 33746434
Thanks
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.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

597 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